Difference Column in Pivot Table

In excel, I can use ‘Calculated Item’ in pivot tables if I want to add a column that shows calculations within a field. Does such a function exist in Quicksight?

I am trying to add a simple column that takes the difference between two columns. In this case the difference between Actuals and 2024 OP2

Hi @Edward_Appiah

QuickSight has calculated fields to meet this requirement

Following is tge general syntax.
Ifelse(scenario=‘Actuals’,data,0)-ifelse(scenario =‘2024 OP2’,data,0) should work.

Regards,
Giri

1 Like

Thank you Giridhar, the formula worked but I can’t get the column to display correctly. I want the difference of variance to be the third column. This is what I get though:

Hi @Edward_Appiah

Can you approach it this way?

Three calculated fields

1 Like