Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am having the Pivot table with the Dimension of BU and TEAM
they Have Excluded some teams which are present in the 2017 and that should not present in the 2018
Bu and Team are Different table and doesn't have any year wise filtration.
Sample Table:
I want to Remove the Highlighted Red Column in the 2018 Report but it is need to Present in the 2017 Report
Kindly help me out
I having the common Filter as Year from the Dimension time
if i select 2017 highlighted red column should display
if i select 2018 highlighted red column should not display
stalwar1marcowedeldevarasu07kaushik.solankimarcus_sommerluismadriz
If Measure2 have values, you cannot, Either you could use If condition for each
Hi Anil,
Kindly help me out with this requirment
May be post sample application to test
Hi Anil it is very difficult to create the sample app same as like that becoz it is very big application
I need to hide only that highlighted team in the 2018
Can you do Suppress When value is Null From Dimension level?
If I suppress based on dimension ,it is not displaying the value in the 2017
But I don't need that in the 2018 but I need to present In 2017
Is there any possible way to write any condition for it
Hi,
Try this on the dimension:
=if(GetFieldSelections(Year)=2017, if( isnull(BU), BU, BU))
make sure to deselect "suppress null values" on the presentation tab
This is possible, Can you make sample?