Forum Discussion
Matrix Table Aggregated Values
I have the matrix table below which shows the consumption of each item per year/month. Now for each row on the right side after the last column I want to show the AVG. Is this possible? I do not wan...
Hi TimmK ,
This should be possible, first you need to turn on the subtotals on column level, you can further modify the subtotals to only calculate on the first level.
Next up you need to modify your measure to perform a different calculation when the total is calculated. This can be done by using a check with ISFILTERED() to determine if there is any filter active in the calendar table. The will mean that you can differentiate between the normal cells inside the matrix and the total being calculated at the far right.
When the total is calculated there are no filters on the calendar table being applied while when you're calculating an individual cell there will be a filter on month.
Give it a try and let me know how it goes!
/ J