Hello,
Trying to get my head around which formula to type for a Pivot Table Calculated Field that sums partial columns.
The desired end results is on the table on the right, which was done manually.
Pivot Table Calculated Field.jpg
Thank you.
J
Hello,
Trying to get my head around which formula to type for a Pivot Table Calculated Field that sums partial columns.
The desired end results is on the table on the right, which was done manually.
Pivot Table Calculated Field.jpg
Thank you.
J
Administrative note
Welcome to the forum
in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?
Please take a moment to read it and attach a sheet accordingly.
Thanks you for helping us help you
Apologies,
I am not able to attach a file, for some reason.
Here is a sample of the data
Thank you
Last edited by Pepe Le Mokko; 04-22-2020 at 02:18 AM. Reason: Removed data - Sheet attached
If you follow the instructions on the yellow banner, you can attach a file, like everybody does.
The paper-clip does NOT work
Your sheet should contain AND some data, AND expected results ( eventually added manually).
Thank you for helping us help you
Thank you.
file attached w/ sample data
Hi, there
According to your mockup calculations, what you need is "Calculated Item"
ribbon.pngItem.png
pls refer to attached file for more details (columns in yellow)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks