Help with expression

[Anonymous]

Hi all,

Please help me with expression in Dimension,

IF(Brand<>'A' and Brand<>'B', if(len(trim(Var1))>0, Country,  TOTAL country)

where Var1 = O, E, K

Country =Q,W, R, Other.

I need, if Brand not equal A or B, show all countries, else show TOTAL (Q,W,R, Other)

Thanks,

[#2]

So you want to see Country, Total, and Total of Country + Total?

[Anonymous]

Ther`s no way to show Country variable and 'TOTAL' in one chart???

[Anonymous]

I want to see Country and TOTAL.

Please see my image below:

Instead of Global use your 'TOTAL'.