renaming column labels, pivots

[Guest]

Hi,
Could someone pls help me with this. I have "weeks" in my column labels.
Sum of 1-Jan-07 Sum of 8-Jan-07 Sum of 15-Jan-07 Sum of 22-Jan-07

As you can see, the lables come up as "sum 01-Jan07". How do I rename
several of these lables to show just "01 Jan07" without the "sum" in front of
it? I know how to rename single lables, but don't know how to do several at
one time.
Thanks
Kirthana

 

[Guest]

Based on what you hvae posted i am assuming that each column is it's own
dimension (field) within the cube. That being the case you can not rename
the fields as a group. You could try hiding that row and in an empty row
above add your own titles...

 

[Guest]

thanks.....you just solved my problem......

Based on what you hvae posted i am assuming that each column is it's own
dimension (field) within the cube. That being the case you can not rename
the fields as a group. You could try hiding that row and in an empty row
above add your own titles...