is there any way to split the subtotals by a sub-dimension in a pivot table?
|Header 1||Header 2||Header 3||Header 4||Header 5||Header 6||Header 7||Header 8|
If I select to compute subtotals for the dimension "MONTH", I can only get the total sum of the row (2016+2017), which is meaningless to me. Also, I don't want to switch YEAR and MONTH dimension, because I'd like to do a comparison by months.
I've also attached a .qvw as an example of what I'm trying to achieve.
Any help will be really appreciated.
Hi Sunny, thanks for your reply, it's really helpful. I think I understood the way it works, does it mind to point me to some resource that can help me with a better understanding of the Pick(Match approach?
I don't think this approach is documented yet, but there are multiple other examples on the community where I have proposed this way of doing things in bar chart, pivot tables etc... if you want I can share those links?