I am trying to add a difference column to my pivot table and I am unsure of the best approach. My data is in a data model. I have multiple measures in the pivot table and I have the "Values" in the Rows of my Pivot Table. in the column I have the year, which is a column in my data model. So I have a two column pivot table where the rows and values are different measures and I would like to add a 3rd column that shows the Difference between the two columns.
What is the best approach for this? Below is a simple example that shows my pivot table and how I have the rows and column setup...
Thanks.
image001-3.png
image001-2.png
Bookmarks