Drill-Down Graphs

[#1]

Hello All,

I have a drill down graph for some sales data.  It starts with month, then goes to week, then goes to products sold.

The issue is I have many products, the majority of which were sold only once or twice. So when I drill down to products sold there is entirely too much data shown.  Is there a way to only show products that were sold more than 25times?

For example, what I see for months is 400 units sold.  Then broken down by week I see 100 units per week. Then by product per week I see 1 unit A, 1 unit B, 1 unit C, 25 unit d, 1 unit e, 30 unit f, etc.  I would like to only see unit D, unit F and any other that had more than 25 units sold.

Thanks

[swuehl]

Try something like

=Sum({<Product = {"=sum(SalesCount)>=25"}>} SalesCount)

If you want to apply the condition only to the dimension Unit, you can check for the current dimension using GetCurrentField():

If(GetCurrentField( GROUP ) = 'Unit',

Sum({<Product = {"=sum(SalesCount)>=25"}>} SalesCount),

Sum(SalesCount)

)

[Nicole-Smith · Accepted solution]

Try something like the following:

[#4]

Thanks that is what I needed.