Try creating a multi-valued control (have to manually define values as your flavor pumps are not defined in a single column but rather spread across multiple columns. Do note that every flavor is a dimension and pump counts are measures. So if you are trying to aggregate (count or sum) multiple flavors at once, the math will be off and wouldn’t make sense. Example: sum of Sales in cities like Bangalore, Delhi, Hyderabad etc makes sense individually but not in a combination of 1 or more cities.
Hope this helps and let us know if any further questions!
Thanks!
