List Box to show amount of categories for products
how can I create a listbox to show the number of categoryappearances for a given product.
Product A has 3 categories
Product B 5 categories
and Product C 7 categories.
So the listbox should contain 3, 5 and 7 as values.
At the moment I have a chart with product as dimension and a simple count(category) as expression but I would like to be able to filter the number so that I can select just the products with 3 categories for example.
Can this be done in the load script? What do I need to do?