Dividing a Dimensionality()=3 / Dimensionality()=2

[MEBG93]

Hello experts,

Is it possible to calculate de % of a lower dimension by its upper total? The result I want to get can be explained better in this excel screenshot:

So Employees from Branch A should be divided by Branch A's Totals. I tried Dimensionality() expression with no success. If i can get the Total Branch Sales' Total group by Branch in the Employees Dimension, may solve the problem.

Many Thanks beforehand!

[mikaelsc · Accepted solution]

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/defin...

use "total" qualifier in your expression (with the Employees as dimension to disregard) 

[MEBG93]

Thanks for the answer mikaelsc, but if I use Total qualifier in the expression, I get the top total (2178). What I'm trying to get is the totals of each Branch (e.g. for Branch A = 100). So I want to ultimately divide Employee / Branch Total (e.g. for Joe in Branch A would be 4/100 )

[mikaelsc]

yes... 

total <Branch>

[Vegar · Accepted solution]

You would need to exclude some of the dimensions in your TOTAL using <fieldA, fieldB>.

Try something like this:

sum(Sales)/sum(total <geography, Branch> [Total Brach Sales])