Heya there boys and girls.
Im hoping someone can help me out, this has me pulling my hair out and no one in my office can help me.
Say:
A2:A300 - sales numbers ranging from $1,700,000 to $18,000,000
B2:B300 - sales managers
C2:C300 - customers
D2:D300 - states/prov
I have a pivot table in that place shows:
The sales manager, then the states, the customers within the states and the sales figures.
Simple, and easy enough.
All this sits within row labels, except sales numbers, they sit in both row labels and values because if it is not, when i ask excel to show me the top10 it produces an error. Within values the sales number are told to display the sum not the count.
When i click on the sort button of the sales numbers under the row labels, click Value Filters, Click Top 10, tell it to sort top 10 based on SUM and click OK, nothing happens.
However if i click value filters and select something like less then and say less then 5,000,000 everything over 5,000,000 just dissapears from the list! It makes no sence from what i can see!
ANY HELP AT ALL! Greatly apprecaited!
Cheers,
Dale
Bookmarks