Hi community,
I'm building a monthly P&L view on a Table block and I'm trying to achieve the following layout:
The user selects one month (e.g. Dec 25) via a page selector, and the view dynamically shows:
- The value for that month
- The value for the same month prior year (Dec 24)
- The absolute variance (CY − LY)
- The % variance ((CY − LY) / LY)
What I've tried:
- Calculated items with offset -12** on the Month column pivot — works great when Month is on Columns, but breaks when Month is on Pages (the page selector filters out the offset month)
My question: Is there a native Pigment way to keep a single-month page selector and still show dynamic LY + variance columns?
Thanks in advance!