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.
Can you attach your workbook? There are so many things that can go wrong with this, it is not possible to tell what the issue is by looking just at the formula.