MOM Trend values by month and Year in Pivot table

[Gopi_E]

Hi Qlikers,

I have a scenario where i need to get MOM value by month and year in Pivot table.

My current table structure is like below

Expression: (Sum(Sales)-Before(Sum(Sales))/Before(Sum(Sales))

Current Issue:
Not getting MOM value for Jan starting month of the year

For Jan - 2023 the value should be consider for -  (Jan-2023-Dec-2022)/Dec-2022.

Could you please guide me to get Jan mom value for this view

Thanks in advance !!

@hic @sunny_talwar  

[Chanty4u]

Hi try this 

If(Month(Date) = 1, 

   (Sum(Sales)-Before(Sum(Sales), 12))/Before(Sum(Sales), 12),

   (Sum(Sales)-Before(Sum(Sales)))/Before(Sum(Sales))

)

[Gopi_E]

Hi Chatny,

Thanks for your reply,

I will try this approach and update you.