Hello All,
Quote often I am wanting to make a pivot table showing the "top 10" in regards to the count of a particular field (Invoice #, to be specific).
I then want to show the "Total Profit" for those customers over the last 12 months.
I am unable to figure out how to show the top 10 customers based on VOLUME (the count of the invoice #), without including it in the pivot table.
I am only wanting the Total Profit for these customers to be shown both in the pivot table, and the pivot chart.
Does anyone know how this could be done? creating a column called "order count" and filtering by that will also not work, as I want the top 10 to update based on the filters/slicers that are applied (ex. certain products, etc...)
I am worried the answer is simply "No", but if someone knows either way, some answers would be appreciated.
Thanks in advance!
Bookmarks