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...
HI Settu,
Thanks for Response..
Once you clear all.. and check HR in Category field..
i.e not descending Order
Can you check it Now,
In sort tab To give the Original or reserved in the load order column