Forum Discussion
Calculating Pivot Table values across rows
I have two rows in a Pivot Table that are interdependent on each other. The sum of the two rows cannot exceed 3, while each row cannot exceed 2 (0, 1 or 2). The problem I'm having is I can't figure ...
SteveNBethesda I believe the easiest way to do that is by adding a few columns to the source data for a regular pivot table. Alternatively, use Power Pivot and some DAX measures. Both demonstrated in the attached file.
Hi Riny,
I appreciate your prompt response, thank you. Unfortunately, I don't see the attached file. Can you please try again.
I appreciate your prompt response, thank you. Unfortunately, I don't see the attached file. Can you please try again.