We are working on a revenue workbook using custom datasets and want to display some of the data in a pivot to show revenue etc. YoY.
That part works fine, but we're looking for a way to add a column that shows the difference.
So:
2026 Revenue = A
2025 Revenue = B
YoY Revenue Change = B-A
Seems like it should be easy but haven't figured it out yet - any ideas?
Is a Pivot the right approach?