Get total from expression of straight table (macro or other solution)?

[#1]

How can I get the total of these columns. I need it to build a pie chart with these values.

Is it possible to get these data with the macro? Or is there some other solution. The picture below.

Thanks!

[giakoum]

sum({$<[ABC]={"A,B,C"}>} [Sales])

[jagannalla]

Hello,

Add another expression and give A+B+C. It just work like Column1 + Column2 + Column3. If you don't want to see the expressions A, B & C just hide those expressions.

Cheers!

Jagan

[#4]

i need total A, total B and total C in other chart. Or variable vA=787085, vB=... or vC...

[giakoum]

if you need total A, total B and total C without dimensions, then this is the expression to go :

sum({$<[ABC]={"A","B","C"}>} [Sales])

or

sum({1<[ABC]={"A","B","C"}>} [Sales])  . This one disregards selections.

If dimensions are involved, this needs to be aggregated using the aggr function.

[whiteline]

sum({$<[ABC]={"A"}>} [Sales])  - total A

sum({$<[ABC]={"B"}>} [Sales])  - total B

sum({$<[ABC]={"C"}>} [Sales])  - total C

if you also want discard the user selections use {1 istead of {$.