Total by Dimension expression & further drilldown

[BrandonN]

Hello All,

Need helps on expression with total functions but when I add additional dimensions the total unable breakdown by the additional dimensions, is there anyway I can breakdown by additional dimensions with total function? 

Expected value for the total Product A = 80, Product B = 60

Currently I am getting 140 which is total of 2 products.

Thank you in advance!

[Or]

Sum(Total Value) means just that - sum the total value ignoring dimensions.

If you would like to total for a specific dimension, you can either use a pivot table (which does this inherently), or use sum(total <field> Value). For further details and explanation you can refer to the documentation:

[anat]

sum(total <category>sal)

[Iswarya_ · Accepted solution]

Hi @BrandonN 

Try like this:

Sum(TOTAL <Category> Value)