Forum Discussion
@Pivot Table and analysis of weather data
I have a personal weather station with almost 14 years of data recorded at 1/2 hour data points. I have turned this txt data into an excel database which has 225,000 records. In the data is low tem...
monicard01 Right-click on a date within the pivot table. Then the menu should show.
That works. Thanks. Any way of ranking the values within the pivot table, for instance highest to lowest. Pivot tables are very powerful as long as you know how to manipulate them.
monicard01 Not sure if this is official functionality, but when you select the first cell to the right of the column headers of the pivot table (in my example file that would be F1) and then select "Filter"
... it will put a filter button on the header row(s) in the pivot table. Then you can use it as on any other table with filter buttons.