Forum Discussion
Temporary custom tables? (Plot grand total)
Sorry for not adding an example. Here´s a dummy file with it.
Lind25 indeed I want to add a row for the "average Days" of the total. I need the resulting plots to be responsive to the date slicer (in other examples, there are a couple more slicers they need to respond to).
The measures I am using in the report are mostly averages, medians, and proportions. I need to add grand total for benchmarking purposes in all of them. So basically I need to plot measures by the group and also plot the "ungrouped metric".
Resolver IHi
I can't access that file. A screenshot/mock up of your desired result would be most useful.
Based on what you are saying, using the ALLEXCEPT function or just applying ALL to some columns, rather than a whole table, should give you the desired result and allow the date slicers to be applied.