Hi,

I had created a pivot table with setup as below:

Column:
- Delivery Date

Row:

- Customer Group

Data as column

- Total amount (sum > normal) (show data of the month)

- Total amount (sum > % difference from previous value) (compare between this month and previous month)

- Aggregate formula (sum_if(is_previous_nmonth("Delivery"."Date",12) = 1,"Delivery"."Total",0) (Tried to get data of previous 12 month, but failed)

eg: 2024-10, will get data of 2023-10

Please advice the aggregate formula or any workaround.

Thank you