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‌

[Anonymous]

hi anil , sample means what you are asking bro, my query is need to eliminate the team only for 2018 and need to present in 2017

[Anonymous]

where should i used this dimension , i have used it in calculated dimension but the result is same

[YoussefBelloum]

Yes it should be used as a calculated dimension.

Like Anil said, if you add sample app, something that replicates what you have on the original one, we can help you more

[Anonymous]

i dont know how can i provide the sample data for this requirment,

please help me out how can i make it as sample

because all the data are loaded from the data base and doing the binary load

how can i provide the sample data in this

[Anonymous]

kindly let me know is there any condition is dr to apply

if there is no team mapped to bu i should not display the team

please help me out