Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |