Hi Gurus,
Does anyone know if it's possible to add a dynamic % threshold calculated column to a Pivot Table in a SuiteAnalytics Workbook?
The scenario is that I have a dataset that looks at transactions from between 0 and 5 months ago. When pivoted, I see month columns like Jun 2026, July 2026, Aug 2026, Sept 2026, Oct 2026. I'd think like a 6th column that calculates the average of the first four months (ex. Jun-Sept) and then compares it to the 5th month (Ex. Oct) to show a % difference between the average of the last few months against the last month to identify anomalies. For example, if the average balance in an account is around $20k for Jun, July, Aug and Sept and then Oct is $50k, we'd like that % difference to be displayed so our team can investigate these higher thresholds.
The problem I'm encountering is getting the formula set up correctly so that it rolls as the months roll.