Suppress lines in pivot table

[chaitanyahublik]

Hi All, 

I have one fact table with around 10 dim & 2 measures. I have build a pivot table as below 

LineCode	LineDesc	Amount
11	ABC	121
12	ABC	122
13	ABC	322
14	LMN	127
15	LMN	230
16	LMN	322
17	LMN	534
18	PQR	334
19	PQR	133

Now I also have filter for currency selection ( lets say I have 5 ccy). Now my requirement is that when there is nothing selected in CCY filter, line 15 should be suppressed (not visible) and as soon as I select the any CCY it should re-appear.

I wrote formula like - if(LineCode= '15' and len(GetFieldSelections(Currency))= 0,null(),LineCode)

It is working but there is another issue, as soon as I select any ccy and then any line code, CCY selection is getting overridden. It now has all the values of CCY instead of the one which I selected before. Any idea what's wrong?

@jagan , @vinieme12 

[sunny_talwar]

@chaitanyahublik Sorry, what exactly is the issue? I don't think I understand the issue? Is there a sample you can share where we can see the issue?

[chaitanyahublik]

Hi Sunny,

 So basically from chart above , I want to hide line  with code 15 when there is no filter selected for CCY. If user selects any currency from filter, this linecode 15 should re-appear.  Its the requirement!

Now I was able to do it with formula - if(LineCode= '15' and len(GetFieldSelections(Currency))= 0,null(),LineCode)

It is working but another issue pops up  as below -

1. On opening the report, as there is no CCY filter selected, line 15 is hidden.

2.Now I select ccy as GBP from filter, and I can see line 15 visible now. So I filter on line 15 (or any other code).

3. No I am seeing that CCY filter has all the possible values of that line selected instead of just GBP we selected earlier. Makes sense? I want to know what is causing this behavior

[chaitanyahublik]

@sunny_talwar Any idea on above?

[sunny_talwar]

@chaitanyahublik would you be able to provide a sample to see the issue?