Need help with conditional expression

[#1]

I am trying to create multiple pie charts on one sheet.  Each pie chart will contain a subset of the overall data I am trying to display with conditional expressions, however I am running into issues.

One of the pie charts I am trying to create should show the number of SKU's based on the following SKU_MODEL however, when I enter this into the conditional portion of the expression it shows all SKU Models, not just the one.  What am I doing wrong?

=Count({$<SKU_MODEL={"CIS"}>}DISTINCT(MATNR))

[#2]

The qv file is extremely large, is there another option to have you look at it?

[phaneendra_kunc]

you can always do a "Reduce Data" to skin down the app size.

select Data some filters that you want and which requires this computation and go to FILE --> Reduce Data--> Keep Possible values. And then you can Save As with a different file name.

if above is not possible just do a small test..

Create a new chart with SKU_MODEL, MTART as dimensions and count(Distinct MATNR) as expression

and share that image

[#4]

Attached is the image for the small test.

[phaneendra_kunc]

Here is the explanation...your expression is already filtered to CIS and it is associated with only FERT and ZMOD in MTART field.

i bet you have 157178 distinct values for CIS. You can test that by removing MTART dimension from the above grid.

even though FERT has 157178 and ZMOD has 11 it doesn't mean that you will get 157189. You are doing distinct.

i Think you have some overlaps in your dataset for both.

if you want to see a change select ZMOD from  MTART field.

[#6]

So is there a way to create separate pie charts for each SKU_MODEL by explicitly calling out each SKU_MODEL and use a single multi box to apply general filters to all of the pie charts? That is what I am trying to do rather than create separate pie charts and multi box for each one.

[phaneendra_kunc]

I Would suggest a simple solution...

add your SKU Model as Dimension and count(Distinct MATNR) as expression in a pie chart.

ffor this chart if you enable Trellis then I will pop out single pie for each SKU Model. Enabling trellis is on properors window of the object and under general or chart..

[#8]

This is a great option however I don’t think it will satisfy my needs. What I am needing is separate pie charts for each SKU_MODEL. It seems that the trellis is breaking out the total pie chart into separate breakdown. I need each pie chart to be independently charted as a percentage of itself, not the whole.

[#9]

This is what I am trying to create without having to do independent multi box objects tied to each chart.

[#10]

Is there a way to accomplish this?