Hi,
Does anyone have any experience of applying formats to pivot table measures conditionally based on their name?
For example, if my measure has a (£) in its name, then apply a currency format, else apply a simple numeric format.
I've done this kind of thing successfully with ordinary pivot tables in the past, but the syntax for OLAP based pivot tables (with measures) seems to be a little different.
Cheers,
Matty
Does anyone have any experience of applying formats to pivot table measures conditionally based on their name?
For example, if my measure has a (£) in its name, then apply a currency format, else apply a simple numeric format.
I've done this kind of thing successfully with ordinary pivot tables in the past, but the syntax for OLAP based pivot tables (with measures) seems to be a little different.
Cheers,
Matty
