Hello, I have a pivot table with various fields. I have units sold for each month for the entire year for a forecast type. I want the previous month units to be shown on the next month so I can create a growth rate calculated field using the units from the previous month and current month. Currently I have the PreviousMonthUnits set to the PurchasedQuantity, but I would want January Units to show for February 2024 and so on. I’ve tried to use lag and firstVaule in calculated fields but neither worked as expect.
I had seen some solution recently that may be similar to your requirement.
See if this helps.
https://democentral.learnquicksight.online/#Analysis-TipsAndTricks-Calculation-Year-over-Year-Table-with-Filtering-aka-Date-Hider-
Regards,
Giri
1 Like
That’s exactly what I was looking for. This did the trick! Thanks.