Issue with creating calculated value in pivot table from two column values
I am having an issue with understanding how/if I can create a calculated field in a pivot table that takes into account columns that have two separate column values.
In my attached example table you can see that column A has two values and columns D-F have years. When I have the pivot table set to include both the sum of the values and the values from column A it makes so that I can't create what I'm looking for within the pivot table.
In the pivot table you see that my rows are by "Reporting work stream" and "Reporting sub stream" this is the way that I need the data to present, but I need to have a total for each year of the Actual + Forecast. When I go into the calculated field There is only "Actual/Forecast" and the years which doesn't seem to do what I need it to.
In my actual deck I've resorted to a table next to the pivot that references the cells in the pivot table, but any time that anything is added or removed it messes with all my formatting and is extremely time consuming to fix.
Thanks in advance for your help!
[link] [comments]
Want to read more?
Check out the full article on the original site