PIVOT Query

[Leighton21]

Hi All,

Is it possible to have two aggregations using the pivot query.

for example if you have the following

Date Product Pice1 Price2
2008 a 1 2
2008 b 3 4
2009 a 3 4
2009 b 5 6

becomes

Date A(price1) B(price1) A(price2) B(price2)
2008 1 3 2 4
2009 3 5 4 6

cheers

 

[SkipVought]

Date in ROW

Product in COLUMN

Pice1 & Price2 in DATA

FINISH

Then drag the DATA icon in the PT to the right until the selection seems to change. At least it works that way in Excel.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

I thought I was in a differnt forum. Please disregard.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]