Value of calculated field not changing with slicer selection

[Ashish Mathur]

Hi,

A have a Pivot Table with three basic Calculated Field formulas and a slicer. When I male a slicer selection, only two of the three calculated field formulas results change, the third one stays as is.

Could you kindly look into this basic file - http://sdrv.ms/11WxK5z and tell me what the problem is.

Thank you.

 

[miguel.escobar]

Hey Ashish!

Basically, there's no relationship between the criteria that you're using as Slicer so you need to create it. First, create a table with unique values for the type of session. Then, relate that table to both tables that have the Type of Session field and last but not least, use that column of your new table as the slicer.

hope this helps!

 

[Ashish Mathur]

Thank you for your help.