I am trying to get an accurate count of products for each customer. The most granular field I have is product name but some product names are actually a grouping of multiple products. I have a list of which product names reference multiple products and want to use it to help solve this issue.
My calculated field currently looks like this:
if [Product Name]="ABC"
elseif [Product Name]="XYZ"
elseif [Product Name]="DEF"
elseif [Product Name]="QRS"
When the product name field is in my visualization I get the correct product count, but when it is aggregated up in any way (sub-total, pulling the field out, etc.) it fails to total correctly. I am looking to get a total of 12 in this example, but am instead getting 4.