To do this, we can create an If โ Then โ Else column which will show the order total only if the Sale or Restock column contains the value 'Sale' and shows the value of 0 if not. We can then use that column elsewhere in a calculation, rollup or chart.