Pivot Table data Issue

[Anonymous]

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

stalwar1‌marcowedel‌devarasu07‌kaushik.solanki‌marcus_sommer‌luismadriz‌

[Anil_Babu_Samineni]

If Measure2 have values, you cannot, Either you could use If condition for each

[Anonymous]

Hi Anil,

Kindly help me out with this requirment

[Anil_Babu_Samineni]

May be post sample application to test

[Anonymous]

Hi Anil it is very difficult to create the sample app same as like that becoz it is very big application

[Anonymous]

I need to hide only that highlighted team in the 2018

[Anil_Babu_Samineni]

Can you do Suppress When value is Null From Dimension level?

[Anonymous]

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

[YoussefBelloum]

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

[Anil_Babu_Samineni]

This is possible, Can you make sample?