Split Subtotals in pivot table

[jekbauita]

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.

[sunny_talwar · Accepted solution]

May be use Pick(Match approach....

[jekbauita]

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!

[sunny_talwar]

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?

[jekbauita]

I think it would be great for someone like me wh would like to understand the mechanism behind the scene.

[sunny_talwar]

Here are some examples

Stacked and Grouped in a single bar chart?

Chart with Dimension of "Today", "current month" and "current month of last year"‌

Pivot problem for adding another dimension | Qlik Community

[Kushal_Chawda]

bhai pehle hi bola tha tuje ki ispe blog likh

[sunny_talwar]

bhai website le li hai...bas blog likhna shuru karna hai.

[Kushal_Chawda]

kab start karega. people are waiting

[sunny_talwar]

Bahut jald