Posted 7 October 2022, 2:24 am EST - Updated 7 October 2022, 2:29 am EST
I am trying to create a summary pivot grid that has the following columns:
- total amount of items in scope
- total amount of items completed
- total items remaining to be completed
Is there a way to make the 3rd column represent the difference between the previous 2 columns? Or is there some alternate way to accomplish this? I tried making the third column a second instance of “total amount of items in scope” and using a showAs calculate of the difference from the previous column, thinking that this would give me the difference I am looking for. However, this produced blank cells, so I must be misunderstanding how the showAs works.