how to calculate and display a measure aggregated at a higher dimension than the table's current level in Qlik Sense?

[Diere29]

I have a table in Qlik Sense (see the first image) that shows data for Division, Product, and Unit Retail Cost. I want to display a summarized version of this table (as shown in the second image) with the total Unit Retail Cost grouped by Division. When i remove the product column it nullifies my formals.  

I tried using the following formula, but it doesn't display any results:

sum(aggr(nodistinct sum({<[Product]=>} UK_IP_INVFIFO.Unit Retail Cost), Division))

What could be wrong with this formula, and hw can I fix it to achieve the desired summary?

what i have currently 

what i want to achieve 

Division	Unit Retail Cost
HOUSEWARES DIVISION	15
WOMEN'S DIVISION	39

[MatheusC · Accepted solution]

Hi, 

Try using the Total qualifier together with the Sum() function.


sum({<[Product]=>} Total <Division> UK_IP_INVFIFO.Unit Retail Cost)


- Regards, Matheus

[Diere29]

Thanks a variable of this worked 🙂