I've failed to see the probably easy solution for this!
I have a pivot table that needs to be sorted after the data field,
not the sum of the rows, more of how the numbers come up.
I can't figure out how to sort IndexNo so that it starts with row 2, and then 1 & 3 (sort the data by column 1, then 2, and so on...)
The real pivot is a lot bigger, but this is to get the idea. :)
Sum of SubQty...I..Materials
IndexNo............I Material 1.....I Material 2..I Material 3...I
----------------+-------------+-----------+------------I
12345...............I........2.................0................1........I
----------------+-------------+-----------+------------I
22222...............I........2.................1................0........I
----------------+-------------+-----------+------------I
66611...............I........2.................0................1........I
----------------+-------------+-----------+------------I
Looking forward to see how dumb I can feel when the solution is presented! ;)
Bookmarks