Is there a way to create a value column that totals the other columns in a pivot table? I'm looking to show a table of fiscal years as columns with campaigns as rows, showing the total for each fiscal year as well as the full multi-year campaign. I can get the rows to sum, but not sure how to add a column at the far right that totals certain columns if that's even possible. Thanks for any thoughts!
Hi Keri,
You can do this by editing the SUM formula in the column you are creating. Click the edit pencil to edit the formula. When you add the amount value with the SUM operator it will likely look something like this. SUM([AMOUNT]) .
What you want to do is add an open parenthesis before SUM so that you have (SUM([AMOUNT])
then add a coma (SUM([AMOUNT]),
then find the value for your campaigns
click on the MORE button.
Select the value as a filter and select only the campaigns you want to total up.
Then close the formula up with a parenthesis. Should be something like (SUM([AMOUNT]), [Campaign])
and hopefully that works! Let me know if I understood your question correctly otherwise I can offer more suggestions!
https://www.tessituranetwork.com/Items/Videos/Webinars/2019/Tessitura_Analytics_Skills
This pop up skill builder was very helpful for me.
Thanks for this Luis!