CY-PY Sales in Pivot Table

[mhmmd_srf]

Hi All,

I have a requirement like below:

In the Act reduction field I need to show (2017 Sales - 2016 Sales) that is 0.207 - 0.018 = 0.189. And that too will show in the last row.

I am using simple Sum({Year = {'2017'}}Sales) - Sum({Year = {'2016'}}Sales) in expression. But it is not showing as expected.

Please help me to do that.

Thanks,

Sarif

[mhmmd_srf]

Got it ..

thanks a lot..