rename the expression label in pivot table

[willinek]

Hi everybody,

i have a realy big problem here an no Idea how to solve it.

I have a pivot table, in which I drag the 2nd dimension to the top. As a result, I get 3 Columns, because my dimension (Values from a data island) always has just 3 values. Furthermore I have got 2 expression (IST and % V). My Problem now is, that I like to rename the expression IST to Plan only for the third value auf dimension 2. But I have no Idea how to accomplish that. Does anybody know how to do that?.

example:

how it is

--------------------------------------------------------------------
Area | Jan 2010 | Jan - Aug 2010 | Total2010 |
--------------------------------------------------------------------
|IST | % V | IST | % V |IST | %V |
------------------------------------------------------------------
V1 | 1 | 1% | 22 | 10% | 23 | 15% |
V2 | 2 | 1% | 23 | 10% | 21 | 14% |
V3 | 3 | 1% | 25 | 11% | 38 | 18% |

how it should be

--------------------------------------------------------------------
Area | Jan 2010 | Jan - Aug 2010 | Total2010 |
--------------------------------------------------------------------
|IST | % V | IST | % V |PLAN | %V |
------------------------------------------------------------------
V1 | 1 | 1% | 22 | 10% | 23 | 15% |
V2 | 2 | 1% | 23 | 10% | 21 | 14% |
V3 | 3 | 1% | 25 | 11% | 38 | 18% |

Thanks in advance

Alex

[johnw]

Perhaps this as your expression's label?

if(YourField='Total2010','PLAN','IST')

[willinek]

Hi John,

thanks for your help, but it is not that easy. I tried out different approches with the Columnno() and dimensionality() functions, but did not succeed at all.

Any other Ideas?

Thanks

Alex