Hi,
I'm trying to create a pivot table as in the picture below.
I want to add a calculated column named Total Deals. Dispatch column has higher priority compared to Deal column. So if Dispatch has a value, it's taken into calculation. Otherwise, Deal is enough. I have seen Grand Total feature but it does something else. Is it possible to achieve what I need using Pivot Table?
TotalDeals => Sum(Dispatch ?? Deal)
Thanks in advance!