Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,...)