Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
mrmoster
Contributor
Contributor

Relative numbers with drill down

I have created a chart where I have a drill down and I have used relative numbers to show the value as the proportion of total per a month. Ideally I would like the proportion when going down a level on the drill down to be of the top level total not the drill down level.

E.g. 

Category (Top Level)Sub Category (2nd Level)Sales
TechItem 110
TechItem 240
ClothesItem 350

 

So I would want item on 1 to show as 10% of total sales and not 25% of sub category level.

Is this possible? 

 

1 Reply
Or
MVP
MVP

Sum(Sales) / Sum ({< Category = >} total Sales) should hopefully do the trick