Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In my DB I have this table:
CategoryID, SortOrder
A 5
B 2
C 3
D 4
E 1
I'd like to show ONLY the categories (joined with other data), in a pivot table SORTED by SortOrder;
Category Month, Hours
E Jan 5
E Oct 8
B Mar 10
B Nov 6
C Sep 9
C Dec 15
D Aug 5
D Oct 4
A Jun 6
A Aug 3
It seems that sorting by a field not shown in the dimension it's not possible in a pivot table; is there a trick to workaround this limit?
Thank you.
N.
...to tell you the truth it should be:
93, 91, 82, 81, 73, 72, 71
However, how did you achieve it? Can you attach the qwv file, pls?
Thks
See Attachment.
Excellent!
I don't understand why it is necessary to specify Min(Ordinamento) and not only Ordinamento, but it's not important....
Thank you to everybody for the help and you, Antonio, for the solution.
N.
It Sorts Stato according to Min value of Ordinamento (aggr by Stato) :
91,81,71 (Desc)
Regards,
Antonio