Hello.

I have a PivotTable with the total of orders by product and status. Example below:

Product A:
Completed: 100
Canceled: 10
Error: 1

Product B:
Completed: 50
Canceled: -
Error: 2

I need a formula thats sums the number of orders by status. I'm using IFERROR(GETPIVOTDATA(#Number of Orders,PivotTable,"Status","Completed"),"-") for the completed and
IFERROR(GETPIVOTDATA(#Number of Orders,PivotTable,"Status","Canceled"),"-") for the cancelled. But I get "-" for the Canceled. This is because there is no orders canceled for Product B. I need this formula to adapt to not having orders in certain status for each order. Meaning I want the formula to return the sum of the values, even if there are some products without any orders.

Best regards,
PDRTXA