Can you aggr () on a Total column ?

[claudialet]

 Please see attached qvf. 

There is an auto generated 'Total' column.   

For row 'yellow' - how do I return the total sum of row 'red'  + row 'purple' instead ?   Should be returning 19.7

[Channa]

in that case what you do about South 6.3

[claudialet]

 That value is to be not displayed. 

Only need to fix 'Total' column . Please help !

[sunny_talwar · Accepted solution]

Do you want one of these?

Top chart expression

If(Description = 'yellow', Sum(TOTAL {<Description = {'red', 'purple'}>}Amount * Rate), Sum(Amount * Rate))

Bottom chart expression

If(Description = 'yellow' and SecondaryDimensionality() = 0, Sum(TOTAL {<Description = {'red', 'purple'}>}Amount * Rate), Sum(Amount * Rate))