Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
is there any way to split the subtotals by a sub-dimension in a pivot table?
For example:
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 |
---|---|---|---|---|---|---|---|
MONTH | JAN | JAN | FEB | FEB | TOTAL | TOTAL | |
TYPE | YEAR | 2016 | 2017 | 2016 | 2017 | 2016 | 2017 |
CAR | 10 | 20 | 15 | 25 | 25 | 45 | |
BIKE | 1 | 4 | 10 | 0 | 11 | 4 | |
HOUSE | 2 | 5 | 8 | 15 | 10 | 20 |
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.
May be use Pick(Match approach....
May be use Pick(Match approach....
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?
Thanks!
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?
I think it would be great for someone like me wh would like to understand the mechanism behind the scene.
bhai pehle hi bola tha tuje ki ispe blog likh
bhai website le li hai...bas blog likhna shuru karna hai.
kab start karega. people are waiting
Bahut jald