# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
New Contributor III

## Split Subtotals in pivot table

Hello,

is there any way to split the subtotals by a sub-dimension in a pivot table?

For example:

MONTHJANJANFEBFEBTOTALTOTAL
TYPEYEAR201620172016201720162017
CAR102015252545
BIKE14100114
HOUSE258151020

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.

Tags (3)
1 Solution

Accepted Solutions
MVP

## Re: Split Subtotals in pivot table

May be use Pick(Match approach....

19 Replies
MVP

## Re: Split Subtotals in pivot table

May be use Pick(Match approach....

New Contributor III

## Re: Split Subtotals in pivot table

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!

MVP

## Re: Split Subtotals in pivot table

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?

New Contributor III

## Re: Split Subtotals in pivot table

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

MVP

MVP

## Re: Split Subtotals in pivot table

bhai pehle hi bola tha tuje ki ispe blog likh

MVP

## Re: Split Subtotals in pivot table

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

MVP

## Re: Split Subtotals in pivot table

kab start karega. people are waiting

MVP

Bahut jald