Pivot Table subtotal error

[Tidr0001]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]
[TABLE="width: 48"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Actual
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 48"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Current
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 48"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Needed
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 87"]
<tbody>[TR]
[TD]Store A
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 48"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Prod A
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[TABLE="width: 48"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Prod B
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-5
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[TABLE="width: 48"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Prod C
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]7
[/TD]
[TD]7
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 87"]
<tbody>[TR]
[TD]Store A Total
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]10
[/TD]
[/TR]
</tbody>[/TABLE]
I have a pivot table with Store, Products, and Sale or Cost.

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.