Good morning,
I have a pivot table calculation question. Below, to the left, is a sample of the underlying data, and to the right, a second image of the pivot table. Currently, the Variance column is calculated outside of the pivot table, so when I filter the table, the formatting in the variance column shows even where there is no data. So, I would like to subtract the Excel column from the the NetSuite column using a pivot table calculated item. The problem I'm having when trying to enter the calculated item formula is that the Source field contains both the Excel and the NetSuite variable. Thus, I am unable to select them individually for the calculated items, but I need them as the pivot table comparator to yield the respective Excel and NetSuite counts.
Any thoughts would be greatly appreciated. Thank you.
Data: Pivot Table Output:
I have a pivot table calculation question. Below, to the left, is a sample of the underlying data, and to the right, a second image of the pivot table. Currently, the Variance column is calculated outside of the pivot table, so when I filter the table, the formatting in the variance column shows even where there is no data. So, I would like to subtract the Excel column from the the NetSuite column using a pivot table calculated item. The problem I'm having when trying to enter the calculated item formula is that the Source field contains both the Excel and the NetSuite variable. Thus, I am unable to select them individually for the calculated items, but I need them as the pivot table comparator to yield the respective Excel and NetSuite counts.
Any thoughts would be greatly appreciated. Thank you.
Data: Pivot Table Output: