Special Pivot.

Anthony1200 · Post by **Anthony1200** » Tue Mar 24, 2009 2:00 pm

Hi guys,

I'm hoping someone can help me

i need to pivot a table like this:
COL1 COL2 COL3 FIN1 FIN2 FIN3

The COL1 to COL3 collums don't need any special formatting
the FIN1 to FIN3 need to be pivotted to REVENUE. So far no problem with a pivot stage.
But here's the problem... FIN1 to FIN3 are listed per period..
so i want an additional column with a PERIOD indicator..

Have you guys got any ideas about that??

Thanks!
Kind regards,
Anthony

ray.wurlod · Post by **ray.wurlod** » Tue Mar 24, 2009 2:09 pm

Upstream of the stage doing the pivoting create more columns containing the name of each period (as constants). Pivot these columns too.

Anthony1200 · Post by **Anthony1200** » Tue Mar 24, 2009 2:20 pm

Thanks Ray,

Well that will take me some time :p 53 weeks times three years ha ha! :p

Thanks!
Kind regards,
Anthony