| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table - creating % of Totals
I am new to Pivot tables. I have created a table successfully with totals and grand totals. All works well. What I am trying now to do is add a formula that calculates the % of the Grand total for each row and column. Help would be appreciated. Cheers, Bernz -- BernzG ------------------------------------------------------------------------ BernzG's Profile: http://www.excelforum.com/member.php...o&userid=22949 View this thread: http://www.excelforum.com/showthread...hreadid=532140 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table - creating % of Totals
You can use custom calculations to show the percent of grand total, as
shown he http://www.contextures.com/xlPivot10.html BernzG wrote: I am new to Pivot tables. I have created a table successfully with totals and grand totals. All works well. What I am trying now to do is add a formula that calculates the % of the Grand total for each row and column. Help would be appreciated. Cheers, Bernz -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table - creating % of Totals
Thanks Debra - that link has solved my problem. :) -- BernzG ------------------------------------------------------------------------ BernzG's Profile: http://www.excelforum.com/member.php...o&userid=22949 View this thread: http://www.excelforum.com/showthread...hreadid=532140 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table - creating % of Totals
You're welcome! Thanks for letting me know that it helped.
BernzG wrote: Thanks Debra - that link has solved my problem. :) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| Button Include Hidden Items in Totals (Pivot Table) never enabled | Excel Discussion (Misc queries) | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
| I am having problems creating pivot table of data | Charts and Charting in Excel | |||
Linear Mode
