Forum Discussion

Copper Contributor

Jul 24, 2023

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 ...

excel

SergeiBaklan

Diamond Contributor

Jul 26, 2023

SteveNBethesda

If you don't see this option

in your Reply message (available not for everyone, have no idea why), please put your file one OneDerive, GoogleDrive, etc,, give access to everyone and share the link.

SteveNBethesda

Copper Contributor

Jul 26, 2023

Thanks to all for pitching in! Here's the link to the file:

https://www.dropbox.com/scl/fi/yjgzjaw8dc3ktn59t64ye/Competition-Submissions-Log.v2.Final.20230726.-TEST-FILE.xlsm?rlkey=c4mrcuxdvlobaei3oc60o8vow&dl=0