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