Hello,
I would like to know if there is a way to have a pivot table show data points as they are shown in the "raw/source" data table. I'll try to illustrate below if possible.
Data as it appears in source table: Data as it appears in a pivot table:
82.8 46.7
82.5 75.6
85.0 76.3
84.9 77.0
83.6 77.1
77.1 78.6
76.3 82.5
46.7 82.8
77.0 83.6
75.6 84.9
78.6 85.0
I'm aware that the data as it is shown in the pivot table is displayed in ascending order but I want the pivot table to show the data as it has been entered in the source data. I might be overlooking something very simple, but the only sorting options I can see are ascending and descending. Is there a non-ascending/descending option?
Thanks,
Teddy
Hello Teddy,
One simple trick is to add a new column in your source data, name it like ID or something like that, and then add for example numbers 1, 2, 3, 4 etc as ID. You can then in your pivot table choose to sort by this ID.
This is just a quick and easy solution, there are most certainly other and probably better solutions, just play around.
Br,
Anders
Hi Teddy,
Anders suggestion is a good one, but you'll need to use Power Pivot to set the Sort By for your column based on an index or ID column.
This post explains the sorting options available in regular PivotTables.
Mynda
Hi Teddy
You can try this trick.
1) Create an empty Table with a header (no data)
2) Create a PivotTable from this empty Table with the header in the Row Labels
3) Now add your data to the data Table (unsorted) and refresh the PivotTable
The Row Label will not be sorted.
Hope this helps.
Sunny
Wow, cool trick, Sunny!
Thanks Mynda. Glad to know you like it.
