Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables - How to display multiple items?
Hi,
I was windering if some one could provide me with a link to a tutorial for what I am trying to do. I have an aggregate table. This table has several groups and several columns. The intersection of a group and column is an aggreate value such as Sum function of a column value in that group. Normally a Pivot table shows 1 aggregate value at the intersection of a group and a column. What I want is: To show more than one value at the intersection besides the aggregate value. In other words, if a simple pivot table cell is: Aggr(x,y) where aggr is an aggregate function such as Sum() I want to be able to show (on separate rows under the same group): Aggr(x,y) F(Aggr(x,y)) G(Aggr(x,y)) Where F and G are functions of a single variable say F(x)=x/2 and G(x) = x/3 I hope this is clear. Note: I tried to do this with adding 'items' but did not work. Thanks much. EK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables - How to display multiple items?
I did not find a way to update the post, so I am adding this to the original
post. 1-I am not asking for a Macro to do this, if some one knows how to do this manualy its OK 2-Adding 'Items' would work if the rows (groups) were constant but in my case, groups depend on the incomming data and can't be predicated. Thanks again... "ekareem" wrote: Hi, I was windering if some one could provide me with a link to a tutorial for what I am trying to do. I have an aggregate table. This table has several groups and several columns. The intersection of a group and column is an aggreate value such as Sum function of a column value in that group. Normally a Pivot table shows 1 aggregate value at the intersection of a group and a column. What I want is: To show more than one value at the intersection besides the aggregate value. In other words, if a simple pivot table cell is: Aggr(x,y) where aggr is an aggregate function such as Sum() I want to be able to show (on separate rows under the same group): Aggr(x,y) F(Aggr(x,y)) G(Aggr(x,y)) Where F and G are functions of a single variable say F(x)=x/2 and G(x) = x/3 I hope this is clear. Note: I tried to do this with adding 'items' but did not work. Thanks much. EK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables - How to display multiple items?
On Jan 8, 9:47*am, ekareem wrote:
I did not find a way to update the post, so I am adding this to the original post. 1-I am not asking for a Macro to do this, if some one knows how to do this manualy its OK 2-Adding 'Items' would work if the rows (groups) were constant but in my case, groups depend on the incomming data and can't be predicated. Thanks again... "ekareem" wrote: Hi, I was windering if some one could provide me with a link to a tutorial for what I am trying to do. I have an aggregate table. This table has several groups and several columns. The intersection of a group and column is an aggreate value such as Sum function of a column value in that group. Normally a Pivot table shows 1 aggregate value at the intersection of a group and a column. What I want is: To show more than one value at the intersection besides the aggregate value. In other words, if a simple pivot table cell is: Aggr(x,y) where aggr is an aggregate function such as Sum() I want to be able to show (on separate rows under the same group): Aggr(x,y) F(Aggr(x,y)) G(Aggr(x,y)) Where F and G are functions of a single variable say F(x)=x/2 and G(x) = x/3 I hope this is clear. Note: I tried to do this with adding 'items' but did not work. Thanks much. EK- Hide quoted text - - Show quoted text - You can use formula in pivot table to add calculated column which contains your formulas like Aggr(x,y) Hope it is usefull. Regards, Madiya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
always display rows in Pivot tables (show items with no data) | Excel Discussion (Misc queries) | |||
Updating pivot items on 3 pivot tables contained on one sheet | Excel Programming | |||
Updating pivot items in three pivot tables on one sheet via VBA | Excel Programming | |||
Name items in Pivot Tables? | Excel Discussion (Misc queries) | |||
Display contents of (Multiple Items) from Pivot Table | Excel Programming |