Hello,
I'd like to incorporate a dax formula or other dynamic function into my power pivot to have an additional criteria added which is the sum of two other criteria.
Attached is a basic power pivot example of my workbook. I have 4 categories and I want a 5th category in the pivot table which is the sum of Revenue and Support (boxed in red).
Thank you,
Roy