Segmenting Pivot

[#1]

I have done a Pivot over our products, but I only wanted the chart to show 4 different product groups - how do I solve this?

[#2]

You can do it with set analysis if you know which groups you want to see, or you can restrict which are displayed if you wanted to see the top four categories, for example. The attached qvw shows a couple different ways.

[#3]

Sorry I'm on a personal lincense, so i can't open your files

[whiteline]

He means instead of simple expression, for example, Sum(Revenue) you should use something like

Sum({$<product_master_name={"Guld Profil", "Spigos"}>} Revenue)

This means we've selected  "Guld Profil" and "Spigos" from product_master_name before calculating the Sum(Revenue).

Try to search in a help index the words "Set Analysis".

[#5 · Accepted solution]

Oh no problem. Using the following example:

So for set analysis, your expressions would look something like this:

Which would give you a result like this:

Or you can show, say, only the top two values by selecting 'Restrict which values are displayed' and selecting 'Show Only Largest X Values'. Deselect 'Show Others'.

This would give you: