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 ???
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.
