Forum Discussion
Prashanth1403
2 years agoNew Member
undefined
I have 50 numeric columns and 1 region column, but theses 50 columns are bifurcated based on category, category column is not present in data so i need a solution to show top10 revenue generated based on category provided
Hello Prashanth1403 ,
you need to unpivot your data so it would be in rows instead of columns, then you could do top 10.
check this out https://youtu.be/URAJ_aDiREE?si=WIsSDLliW79RQx68
1 Reply
- IdrissshatilaSuper User
Hello Prashanth1403 ,
you need to unpivot your data so it would be in rows instead of columns, then you could do top 10.
check this out https://youtu.be/URAJ_aDiREE?si=WIsSDLliW79RQx68