toffee_girl
New Member
- Joined
- Sep 16, 2016
- Messages
- 3
Hi,
Hoping somebody can help with what feels like it should be easier than I'm finding it please!!
I have two pivot tables set up both with customer names as the row labels and column labels being financial years, the values in the table are then the sum of sales volumes to each customer for this year and the prior year.
On the first one I want to just filter for the top 10 based on volume in the current year but when I apply the standard top 10 filter on sum of volumes it filters based on the total sales volumes across all years, similarly on the second one I want to filter based on who were the top 10 last year. Is there an easy way of being able to select a specific column against which to apply the top 10 filter?
Any help much appreciated
Thanks![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Hoping somebody can help with what feels like it should be easier than I'm finding it please!!
I have two pivot tables set up both with customer names as the row labels and column labels being financial years, the values in the table are then the sum of sales volumes to each customer for this year and the prior year.
On the first one I want to just filter for the top 10 based on volume in the current year but when I apply the standard top 10 filter on sum of volumes it filters based on the total sales volumes across all years, similarly on the second one I want to filter based on who were the top 10 last year. Is there an easy way of being able to select a specific column against which to apply the top 10 filter?
Any help much appreciated
Thanks