SubTotal

[pgalvezt]

Hello,

I have a pivot table with Typical information Actual Year -Budget - Last Year. The pivot goes well. But Budget dont have a column in excel, just bring information to account level so for each account qlikview obviously repeat the same total.

So I would like to show only the the subtotal budget when I do clic (Drill Down) on the last level. All value they have to be null...

I put an excel example for better understanding.

Thanks!

[sunny_talwar]

Would you be able to share the sample application to try it out?

[pgalvezt]

Hi Sunny,

Left a qvw example...

[sunny_talwar · Accepted solution]

Can you try the attached

[pgalvezt]

Nice Sunny Thanks!

Could You pls explain how did you get this?

[sunny_talwar]

Dimensionality() function returns a different number based on the collapsed/expanded dimension. In your case you have three dimensions, when we have all expanded, dimensionality() gives 3

When the DescrFormREM is collapsed, dimensionality() will give 2

and so on...

Using that I told the expression to show Plan when Dimensionality() <= 2