YoY of multiple metrics in Pivot

Hi
How can I add a row like the following to do a difference of multiple metrics(not just one metric/value) in QuickSight?

image

You need to make a calculated field for each metric. You can you the period over period difference function for each column.

However, this won’t get you a new row. It will give you more columns. In order to get a new row, you would need to use SQL. Calculated fields create columns, not rows.

Thanks Max, I realized for Level Aware calculated fields I need to use difference() as periodOverPeriodDifference() may not work.

1 Like