Removing Dimension from the context straight table

[Anonymous]

Hi All,

For example, i have sales in various countries in various years, I have a straight table with the country as a dimension. I have sum(Sales) as one expression. In second expression I need the sum of sales across all the countries besides my expression1.

Thanks in advance

[sunny_talwar · Accepted solution]

May be this

Sum(TOTAL Sales) - Sum(Sales)

[Anonymous]

Thank you sunny. I have been using the TOTAL in the wrong way.

[sunny_talwar]

How were you using it?