Hiding Expression In Pivot Table

[rahulsingh12]

Hi,

I have a pivot table with 2 columns namely Month,Flag(Value: STW,STR)

I have written 5 expression and I want the first 3 expression to display for Flag value='STW' and last 2 expression to display only for Flag Value:'STR'

How can I achieve this.

Thus in total if I pivot the flag column I'll have 3 expression under STW flag and 2 expression under STR flag.

Regards,

[Anonymous]

Hi,

as far as I know, this is not possible.

But you could change your data model and use only one expression: and separate your expressions by different dimensions...  or by calculated dimensions...

Search for concatenated fact table...