Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am facing one sorting problem in Pivot Table..
I have 3 dimension, and one expression..
I am showing Category--->Name----> Technology wise rating.
My output should be Ascending Order
OutPut1:
Category | Name | Technology | Rating |
Operations | Deepak | Qlikview | 5 |
Paul | Qlikview | 4 | |
Ramesh | Qlikview | 3 | |
Sai | Tableau | 4 | |
Santu | Tableau | 3 |
OutPut2:
Operations | Deepak | Qlikview | 5 |
Paul | Qlikview | 4 | |
Sai | Tableau | 4 | |
Santu | Qlikview | 3 | |
Santu | Tableau | 3 |
OutPut1 is Technology wise Ascending Order
OutPut2 is Rating wise Ascending Order
PFA,
Hope you Understand..
Thanks in Advance...
There are two outputs what you need exactly!
Check this,
HTH,
Hirish
I want 2 charts and 2 outputs
As i can see there is no perfect match with your Fields .As of Your mentioned example and your app.Check this,
HI Hirish,
Thanks for Quick response....
You did here manually using Match function.. But i have various Categories
I given just sample example for Operation,
Hope you understand ....
Hi ,
PFA Qvw. Hope that helps you.
Regards,
Saurabh
Hi ,
The below link is useful to you
Hi,
Check the Attachment.. You can try with Concat and Match function..
Concat will generally give the sorted value. I created one variable and applied it..
PFA,
I have copied source data and output data also
In that 2 sheet (Source Data and Output Sheet's)