Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
johnnyjohn
Creator
Creator

Change calculation for breakdown row in Pivot Table

Hi, 

I have the table below. I want to create different calculations based on the dimension in the Pivot Table. 

For example, the top row, POV is calculated with count(level1_order). I want the POV and VWAP below the top POV row (marked in red) to be calculated with count(level2_order)?

How can I do this? 

johnnyjohn_0-1661242170611.png

 

Labels (4)
1 Solution

Accepted Solutions
Or
MVP
MVP

Use Dimensionality()

If(Dimensionality()=1,Count(Level1),Count(Level2)) or whatever else you need (you can also use Pick() with your Dimensionality if relevant)

View solution in original post

1 Reply
Or
MVP
MVP

Use Dimensionality()

If(Dimensionality()=1,Count(Level1),Count(Level2)) or whatever else you need (you can also use Pick() with your Dimensionality if relevant)