Dimension value in Expression tab

[polisetti]

Hi all,

I have 3 dimensions coming from Database. I want to show them in a table(two columns in dimensions and third column in expression).Currently, i have added the third dimension in dimension and in expression tab too. And thIn i have hidden dimension in presentation tab.

Is there any string function which i can add directly in expression so that i can remove hidden dimension?

I tried using firstsortedvalue and maxstring function, but those are only displaying top record for that level. But i have multiple records for same level. How can I achieve this ???

Regards,

Polisetti

[techvarun]

Hi

Add three dimensions and one dummy expression (May be number 1) and hide the expression.

Thanks,

Varun

[#3]

Hi Varun,

We want to create the view in pivot table so that it can be seen either in pivot up or pivot down. But pivot table doesn't have option to hide dimension or expression.

Is there any function for this?   All my dimensions are strings.

[techvarun]

Is it possible to share sample data?

[techvarun]

HI,

Please try the attached