AdHoc Report - how to - when select a filter, automatically display another 2 more filters?

[jim_chan]

Hi guys, 

i am creating adhoc report. user is looking for - when i select a field in this dimension list, it will automaticllay display another 2 more dimensions in the pivot table. 

But i failed to do so, when i un-select the dimension, the other dimension to display in the pivot table, how should i script?

Sample scenario: i select on 'Exclusive' , it will automatically display the 'From To' date. 

But wheni unselect Exclusive, the From to date still there. 

My Expression:

My ShowColumn IF

=If(GetSelectedCount(%P_Dimension)='Exclusive',0,1)

So, my expected result is, the FromToDate dimension , ONLY display out WHEN i select the Exclusive. When i Un-select Exclusive, FromTo Date will not be displayed on the Pivot Table.

Please help!

Rgds

Jim

[edwin]

getselectedcount returns the number of selected values - its result is numeric.  you cant compare it with a string.  maybe what you wanted is if( getselectedcount (...) =1,...)