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: 
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