S Shay A Member Jun 25, 2016 #1 Hello, Is there a way to have the calculated item working on the pivot table totals rather than sum up the items? TY! Attachments Calculated Item.xlsx 78.9 KB · Views: 10
Hello, Is there a way to have the calculated item working on the pivot table totals rather than sum up the items? TY!
N NARAYANK991 Excel Ninja Jun 26, 2016 #2 Hi , Can you be more precise in what you want ? Suppose you introduce a Calculated Field , whose formula is : =SALES and in the Value Field Settings , you show it as : % of Column Total you will get the percentage of each sales figure as a percentage of the Grand Total. Narayan
Hi , Can you be more precise in what you want ? Suppose you introduce a Calculated Field , whose formula is : =SALES and in the Value Field Settings , you show it as : % of Column Total you will get the percentage of each sales figure as a percentage of the Grand Total. Narayan
S Shay A Member Jun 26, 2016 #3 Hi, I want to see the % difference between 2013 and 2012, also for the grand total. Meaning (USD 11,018,124/ USD 10,388,246 )-1 = 6% TY
Hi, I want to see the % difference between 2013 and 2012, also for the grand total. Meaning (USD 11,018,124/ USD 10,388,246 )-1 = 6% TY
N NARAYANK991 Excel Ninja Jun 27, 2016 #4 Hi , See the uploaded file. Narayan Attachments Calculated Item.xlsx 89.3 KB · Views: 4
