List Box to show amount of categories for products

[#1]

Hey community,

how can I create a listbox to show the number of category appearances for a given product.

Example:

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?

Thank you,

Thorsten

[bbi_mba_76 · Accepted solution]

Hi,

something like the attached sample

[MK_QSL]

Something like below in script...

===

T1:

Load

     Product,

     Category,

     Sales

From ......

Join

Load

     Product,

     Count(Category) as TotalCategory

Resident T1

Group By Product;

===

Now you can use TotalCategory as List Box

Hope this helps..