# How to show "last year" data in a Pivot table in Workshop?

**URL:** <https://community.palantir.com/t/how-to-show-last-year-data-in-a-pivot-table-in-workshop/4570>\
**Category:** Ask the Community\
**Tags:** workshop\
**Created:** [July 23, 2025, 3:55pm UTC](https://community.palantir.com/t/how-to-show-last-year-data-in-a-pivot-table-in-workshop/4570 "2025-07-23T15:55:08Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Phil-M](https://yyz1.discourse-cdn.com/palantir/user_avatar/community.palantir.com/phil-m/32/4134_2.png) [@Phil-M](https://community.palantir.com/u/Phil-M)\
**Post date:** [July 23, 2025, 4:34pm UTC](https://community.palantir.com/t/how-to-show-last-year-data-in-a-pivot-table-in-workshop/4570/2 "2025-07-23T16:34:39Z")

</div>

Hi @VincentF.

you are poking into the vasp nest here - this is currently not possible with vanilla pivot table functionality. I am (selfishly 😇) pinning my thread on [enhancements to unleash the potential of pivot tables](https://community.palantir.com/t/enhancement-proposals-to-unleash-the-potential-of-pivot-tables/3770) here where I propose one feature exactly solving your case at hand and where I would love to get PD input on.

Currently, we are solving this by pre-aggregate data to specific defined dimensions (like region, account, product) per month and join the “last year” (current year month -12 months) sales as individual column. This way you can set up your pivot table formula for YoY Growth = sum(sales) - sum(sales-1yr) which will look like this:

 ![image](https://canada1.discourse-cdn.com/palantir/original/2X/e/ee21bfd64af24ac169ae22fa01148b981b7d14ca.png)

Since your data is at daily aggregate, you would self-join in two columns, one for sales\_-30 days (Month over Month growth) and sales -365 days (Year over Year Growth).

Note: with derived properties, I believe it is possible to aggregate the last year sales on the fly in workshop. However, you still have to to pre-aggregate your data, so that you have the fixed monthly/quarterly/yearly sum and the pk\_last\_year for the search around to aggregate the sales\_-1yr. You could _not_ just have your backing data to be each individual sales transaction…

 ![image](https://canada1.discourse-cdn.com/palantir/original/2X/e/e02ee816a80eee2244d18c02e4bb76a4db42f695.png)

Hope this helps!

---

_[View the full topic](https://community.palantir.com/t/how-to-show-last-year-data-in-a-pivot-table-in-workshop/4570)._