Hello,
I have a pivot table that currently shows the following:
<tbody>
</tbody>
However, the issue I am having is that I don't want the "COUNT OF ITEM CODES" to include a count where the field in data source, "Quantity on Hand" = 0. While the SUM of Total Value would not be affected by this filter, I would want COUNT OF ITEM CODE to reflect correctly...see below:
<tbody>
</tbody>
Any help is greatly appreciated!
Thanks,
Jay
I have a pivot table that currently shows the following:
Column Labels | ||||
EXPIRED | COMING UP TO EXPIRATION | |||
Row Labels | Count of Item Code | Sum of Total Value | Count of Item Code | Sum of Total Value |
Tables | 74 | $817,008 | 27 | $68,000 |
Chairs | 3 | $422 | 19 | $900,000 |
Books | 18 | $254,000 | 20 | $143,291 |
<tbody>
</tbody>
However, the issue I am having is that I don't want the "COUNT OF ITEM CODES" to include a count where the field in data source, "Quantity on Hand" = 0. While the SUM of Total Value would not be affected by this filter, I would want COUNT OF ITEM CODE to reflect correctly...see below:
Column Labels | ||||
EXPIRED | COMING UP TO EXPIRATION | |||
Row Labels | Count of Item Code | Sum of Total Value | Count of Item Code | Sum of Total Value |
Tables | 50 | $817,008 | 27 | $68,000 |
Chairs | 1 | $422 | 16 | $900,000 |
Books | 17 | $254,000 | 20 | $143,291 |
<tbody>
</tbody>
Any help is greatly appreciated!
Thanks,
Jay
Last edited: