topic Hiding an entry in a table without affecting the total in App Development

Hiding an entry in a table without affecting the total

Ron1 — Mon, 19 Aug 2019 15:06:45 GMT

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

Re: Hiding an entry in a table without affecting the total

sunny_talwar — Mon, 19 Aug 2019 19:54:45 GMT

Try this expression

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

Re: Hiding an entry in a table without affecting the total

Ron1 — Mon, 19 Aug 2019 20:50:42 GMT

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

Re: Hiding an entry in a table without affecting the total

sunny_talwar — Tue, 20 Aug 2019 10:42:09 GMT

For some reason it seems to work for me