Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 239
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
always display rows in Pivot tables (show items with no data) Tausif Excel Discussion (Misc queries) 1 August 4th 09 01:14 PM
Updating pivot items on 3 pivot tables contained on one sheet klysell Excel Programming 2 August 9th 07 07:00 PM
Updating pivot items in three pivot tables on one sheet via VBA klysell Excel Programming 0 August 8th 07 07:20 PM
Name items in Pivot Tables? Sheila D Excel Discussion (Misc queries) 4 December 1st 06 02:54 PM
Display contents of (Multiple Items) from Pivot Table Pasha[_2_] Excel Programming 0 October 13th 05 12:40 AM


All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"