Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
something like the attached sample
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..