Pivot Table / Subtotals whithout detail lines at zero

[#1]

Hi Guys,
A small question to improve your skills (mine? )
I have a pivot table that shows stock figures with countries, locations, suppliers and items as Dimensions and quantity and cost as Expressions.
Some of the items have a quantity = 0 with a cost <> 0
I had a test with IF in my expressions not to show Qty and Cost : it works well.

My issue is in the subtotals : they show totals including items at 0 quantity even if they don't appear in the pivot table.
I would like totals without those lines at 0 quantity
If someone had a magic idea, it mould be very appreciated

Best regards

Mederic

[Jason_Michaelides]

Can you post your expressions?

[#3]

Hi Jason,
Find below the expressions for the Quantity and the Cost :

= IF(sum({< Calendrier.Année = {*} , Calendrier.Mois = {*} , Calendrier.Date = {"<=$(=Date(vDate_End))"} >}
SUIVI_STOCK.Quantity)>0
,sum({< Calendrier.Année = {*} , Calendrier.Mois = {*} , Calendrier.Date = {"<=$(=Date(vDate_End))"} >}
SUIVI_STOCK.Quantity)
,0)

= IF(sum({< Calendrier.Année = {*} , Calendrier.Mois = {*} , Calendrier.Date = {"<=$(=Date(vDate_End))"} >}
SUIVI_STOCK.Quantity)>0
,sum({< Calendrier.Année = {*} , Calendrier.Mois = {*} , Calendrier.Date = {"<=$(=Date(vDate_End))"} >}
[SUIVI_STOCK.Unit price])
,0)

Sorry, the calendar fields are in French.