Forum Discussion
Excel Parent Grand total instead of Grand Total for Pivot Table
Hello, first time posting here.
I'd like to inquire about the way to get % of grand total, but instead of the entire data, its parent grand total for Pivot Table. Is something like this possible?
The table that i attached is the percent parent total, but I need the green cells to be the percentage of the orange cells.
Thank you!
8 Replies
I'd try with DAX measure which depends on content returns this or that result.
- Is this feature available in excel for mac?
jksinamo
Nope, if you are on Mac afraid DAX won't work.
Definitely possible. Could you attach an actual spreadsheet rather than just an image? That would help anybody here help you. With an image -- despite the saying about pictures and how many words they're worth -- one can only assure you that what you're asking is possible.
An image leaves some questions unanswered: where's the raw data on the basis of which those percentages are being calculated? And I assume that you're saying the figures in green in any given section should be percentages of the dark orange off to the right (the pale one is close enough to the orange part of the spectrum to raise that question).......
Anyway, posting an actual spreadsheet would help us give you the actual formulas.
- Thank you for the response! I just uploaded the spreadsheet
You hadn't mentioned that it was a Pivot Table in your first post. So I played around with the field setting (right click on the field in the pivot table area, and then pick "Show Data As")
I am not sure if this is what you were looking for, but I am pretty sure that you'd find the result by playing around with that setting.
If that's not it, come back and clarify.
