ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table - report product that have sales above defined level (https://www.excelbanter.com/excel-discussion-misc-queries/59630-pivot-table-report-product-have-sales-above-defined-level.html)

richard

Pivot Table - report product that have sales above defined level
 
Hi,

consider an examle of data and a pivot table like in the page of famous jon:
http://peltiertech.com/Excel/Pivots/pivottables.htm, namely the most left
table in the third row.

I want to report all product that have sales above 8000. Other product i do
not want to see in the table.

I know how to report 3 best products but it is not i need.

Thank you

riso


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com