Variance between 2 columns in a Pivot Table
LomboMay 14 2013 — edited May 14 2013Hello,
We have an analysis that is a Union of 2 analysis. It has two result columns in the Union, each column have a value of one month. We have to create a third column with the variance between the second and first column.
We are using a Pivot Table and creating a New Calculated Item in the month column with difference between the columns ($2 - $1). But this results in four different columns - The 2 original ones and the difference repeated (for each month).
Pls. is there a way to build the pivot table the way we need it ? with just the 3rd column as a variance result.
Txs for any help.
Antonio