I have two tables in a data source and linked by province and subcategory. I would like to calculate the sales of the distinctive products in relevant provinces. However, my formula returns the same value as sales. Please see my formula below.
IF [Product Sub-Category (Distinctive)]=NULL
I'm not sure where went wrong. Can someone help with this?