Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - display only sum and count if greater then 5
Hi I created a pivot table for based on items with sum qty and count qty..
The table is sorted by item no. and i only want to display if sum of qty and count of qty is greater then 5. definations. Sum of Qty (added all the qty ordered) County of Qty (counted the number of times an item was ordered) eg item no Sum of Qty Count of Qty 234 10 7 456 20 4 789 3 3 Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table fields that are greater than 256 | Excel Discussion (Misc queries) | |||
How to average numbers greater than zero in a pivot table | Excel Worksheet Functions | |||
Pivot Table - only show dates greater than =today() | Excel Discussion (Misc queries) | |||
How to DISPLAY all data values in Pivot Table...not count, sum, etc | Excel Discussion (Misc queries) | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) |