Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Legend without perform unpivot operation.

 

Hello everyone,
We have a table where we have 4 columns. Based on the 3rd column i want to create a legend first 0 represent “A”, 2 represent “B”, 3rd represent “C” and so on. I want to extract and assign all string according to that. I can do that but the main problem is we have to perform unpivot operation, it cause of increasing the record by 7 time. And my data will be increase by 40 Cr in a table. Is there any other way to show legend without performing unpivot. I wan to create column chart with this scenario.

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , if there are numeric columns, where you can create measure, you can create a calculation group

     

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0