Hiding an entry in a table without affecting the total

[Ron1]

Hi All,

I have one table where I am having two dimensions and one measure. I want to hide one dimension value and associated measure without affecting the total.

Please find below example:

Input table:

Region	Country	Sales
APAC	India	12
APAC	PO	4
EMEA	France	10
EMEA	PO	2
EMEA	Italy	8

Now while showing, I will hide the row when Country='PO' without affecting the total

Output should be like this:(In output total all the values will be calculated including 'PO', but the entry for PO will not be shown)

Region	Country	Sales
APAC	India	12
	Total	16
EMEA	France	10
	Italy	8
	Total	20
Total		36

Please help me on this. I will be doing this using Pivot table, but whenever I am hiding the 'PO' from Dimension, it is impacting the total

[sunny_talwar]

Try this expression

=If(Dimensionality() = 2, Sum({<Country -= {'PO'}>}Sales), Sum(Sales))

[Ron1]

But 'PO' is still showing in the table. If we apply a condition in dimension such as (If(Country<>'PO',Country)) , it is hiding the 'PO' entry but the total is also getting impacted.

So it doesn't work

[sunny_talwar]

For some reason it seems to work for me