Pivot Table - PYG expression

[#1]

Hello,

I´m trying to create the PYG expression in a pivot table, but it shows the racio in the homologous month and the value in the current month.

This is the expression I used:

=Num(

( Sum(ProjectedSalesUnits)
-
Sum({$<Year=, Month=,YearMonth={"$(=Only(YearMonth)-100)"}>}ProjectedSalesUnits))
/
Sum({$<Year=, Month=,YearMonth={"$(=Only(YearMonth)-100)"}>}ProjectedSalesUnits)
,'#.##%')

Thanks!!!!

[sunny_talwar]

I am not sure I understand your question. What I can suggest is to break down your formula into pieces and check which piece is giving you potential issues. So I would create =Sum(ProjectedSalesUnits) as an expression and then Sum({$<Year=, Month=,YearMonth={"$(=Only(YearMonth)-100)"}>}ProjectedSalesUnits)) this as another expression and see if it is indeed showing value.

It might be more helpful if I can have some data to play with.

Best,

S

[#3]

Thanks for your help!

I´ve done it before in a text object and the expression is correct.

The problem is that it shows the correct data on the totals, but it doesn´t in the selected month.

Here it goes another exemple.

[sunny_talwar]

I am not sure if you are trying to achieve this or not, but please check. PFA

Best,

S