| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Show SUM of field value in other column
Hi all,
I have a pivot table, in that my data is arranged in given manner: % RPW ..01% ..02% SUM:.03% I want one more column which show this SUM, in each row: % RPW Total ..01% .03% ..02% .03% Note: Fields are in pivot table, so we can not take any cell refernces, here we can use only calculate items for formula but iam not able to find workaround for this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Show SUM of field value in other column
Suppose I have 2 columns in the initial data. Drag 1st field to the 'row
field section', 2nd field to both 'column field section' and 'data items section'. If this post helps click Yes --------------- Jacob Skaria "arun" wrote: Hi all, I have a pivot table, in that my data is arranged in given manner: % RPW .01% .02% SUM:.03% I want one more column which show this SUM, in each row: % RPW Total .01% .03% .02% .03% Note: Fields are in pivot table, so we can not take any cell refernces, here we can use only calculate items for formula but iam not able to find workaround for this. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Show SUM of field value in other column
Hi Jacob,
Scenario is that. % RPW column is created from "Calculated Item" formula from other column in pivot table.So this is not visible in pivot table field lists. So dude i want my sUM into diffrent column having .065 in each row. %Total(pivot tabe field) %RPQ(Calculated Item Field) SUM ..06 .06/2=.03 .065 ..07 .07/2=.035 .065 SUM:.065 "Jacob Skaria" wrote: Suppose I have 2 columns in the initial data. Drag 1st field to the 'row field section', 2nd field to both 'column field section' and 'data items section'. If this post helps click Yes --------------- Jacob Skaria "arun" wrote: Hi all, I have a pivot table, in that my data is arranged in given manner: % RPW .01% .02% SUM:.03% I want one more column which show this SUM, in each row: % RPW Total .01% .03% .02% .03% Note: Fields are in pivot table, so we can not take any cell refernces, here we can use only calculate items for formula but iam not able to find workaround for this. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Show SUM of field value in other column
If you are looking of grand totals for rows...
Right click|Pivot Table Options window| Check Grand totals for rows. If this post helps click Yes --------------- Jacob Skaria "arun" wrote: Hi Jacob, Scenario is that. % RPW column is created from "Calculated Item" formula from other column in pivot table.So this is not visible in pivot table field lists. So dude i want my sUM into diffrent column having .065 in each row. %Total(pivot tabe field) %RPQ(Calculated Item Field) SUM .06 .06/2=.03 .065 .07 .07/2=.035 .065 SUM:.065 "Jacob Skaria" wrote: Suppose I have 2 columns in the initial data. Drag 1st field to the 'row field section', 2nd field to both 'column field section' and 'data items section'. If this post helps click Yes --------------- Jacob Skaria "arun" wrote: Hi all, I have a pivot table, in that my data is arranged in given manner: % RPW .01% .02% SUM:.03% I want one more column which show this SUM, in each row: % RPW Total .01% .03% .02% .03% Note: Fields are in pivot table, so we can not take any cell refernces, here we can use only calculate items for formula but iam not able to find workaround for this. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Show SUM of field value in other column
Jacob,
Simply i want, (the SUM show in both rows, if we add .01 & .02) % RPW Total ..01% .03% .02% .03% Hope u got my point. "Jacob Skaria" wrote: If you are looking of grand totals for rows... Right click|Pivot Table Options window| Check Grand totals for rows. If this post helps click Yes --------------- Jacob Skaria "arun" wrote: Hi Jacob, Scenario is that. % RPW column is created from "Calculated Item" formula from other column in pivot table.So this is not visible in pivot table field lists. So dude i want my sUM into diffrent column having .065 in each row. %Total(pivot tabe field) %RPQ(Calculated Item Field) SUM .06 .06/2=.03 .065 .07 .07/2=.035 .065 SUM:.065 "Jacob Skaria" wrote: Suppose I have 2 columns in the initial data. Drag 1st field to the 'row field section', 2nd field to both 'column field section' and 'data items section'. If this post helps click Yes --------------- Jacob Skaria "arun" wrote: Hi all, I have a pivot table, in that my data is arranged in given manner: % RPW .01% .02% SUM:.03% I want one more column which show this SUM, in each row: % RPW Total .01% .03% .02% .03% Note: Fields are in pivot table, so we can not take any cell refernces, here we can use only calculate items for formula but iam not able to find workaround for this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Field Names Don't Show | Excel Discussion (Misc queries) | |||
| Show text field if SUM returns zero value? | Excel Discussion (Misc queries) | |||
| Show field list does not appear | Excel Discussion (Misc queries) | |||
| Need formula to show if a field hasn't been updated | Excel Worksheet Functions | |||
| I've put a formula in a field, the result won't show | Excel Discussion (Misc queries) | |||
Linear Mode
