<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> | 3 | 3 | 3 | |||
<tbody> </tbody> | -5 | ||||||
<tbody> </tbody> | 7 | 7 | 7 | ||||
<tbody> </tbody> | 5 | 5 | 10 |
<tbody>
</tbody>
Each Store has products that fall under it and some products have positive sales while others have negative costs.
In the Pivot Table, I have a calculated Field where if the product had positive sales, capture the amount.
If the product had negative sales (or cost) return 0 (zero - positive sales)
=IF(Jan Sales > 0, Jan Sales,0)
At the product level, this works fine.
However, when the Pivot Table calculated the Subtotal for each store, it is reducing Sales by those negative sales (or cost) I am looking to remove.