Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot tables
Thank for helping me whith this. I nned to create a calculated fiel where
ia can divide a value in a row by the total of the value column. sonething like this. +A35/A100 where A100 is the total of the colum. So the result will be a porcentage. This have to be a calculated field inside the pivor table. Thank for your help. -- MG |
#2
|
|||
|
|||
Instead of a calculated field, you can add data fields to the pivot table.
In the pivot table wizard, double-click the data field button Click the Options button For 'Show data as', select % of column. mariagloria wrote: Thank for helping me whith this. I nned to create a calculated fiel where ia can divide a value in a row by the total of the value column. sonething like this. +A35/A100 where A100 is the total of the colum. So the result will be a porcentage. This have to be a calculated field inside the pivor table. Thank for your help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Add the items you are totalling twice to the data area, i.e. assume the
header that you have in the data area is called amounts, right click in the pivot and select the wizard, select layout and drag the amounts header a second time to the data, double click it, select options and % ot total -- Regards, Peo Sjoblom "mariagloria" wrote in message ... Thank for helping me whith this. I nned to create a calculated fiel where ia can divide a value in a row by the total of the value column. sonething like this. +A35/A100 where A100 is the total of the colum. So the result will be a porcentage. This have to be a calculated field inside the pivor table. Thank for your help. -- MG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Loosing My Pivot Tables during SAVE AS | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |