PivotTable Calculations
Multiply the Qty by 1 or 0, depending on wether it
falls inside or outside the date range.
=Qty*IF(AND(Date=Begin,Date<=End),1,0)
In Layout, remove the page entry and
move Item into COLUMN.
Update DATA to point to the new quantity.
|