Is it possible to return the value in a column when the value is null?
Example if in Row NORTH since Total Sales is NULL then show the value in Regional Sales.
|TOTAL SALES||REGIONAL SALES|
The only examples I see is to show an expression such as if Total Sales is null then "No Sales"
2 new calcs:
if isNull(sum(([Total Signs])) then sum([Regional Sales]) else sum([Total Signs]) end
and the opposite for the other one