Drilldown group in Expression?

[#1]

Hi All,

I have stock data like this

labst-unrestricted stock

umlme-stock in transfer

insme-quality inspection

speme-blocked stock

all are fields in one table and all fields having numeric data.

requirement is:

In bar chart by default need to show total stock nothing but sum of all stocks for "material wise". for example if we select one material then it should show detailed stock for that material means unrestricted stock,stock in transfer,quality inspection ........etc

just like year and month drill down group.

Thanks,Ashok.

[raptibhowal]

Instead of drilldown You can perform this task as cyclic Expression. Go to Expression Tab select the expression and group the expression, it will be performing as per your requirement like select the material and then change to unrestricted stock, stock in transfer etc...

[#3]

I know cyclic group but in cyclic group at a time we can see one expression only , but i need all expressions when i select any material.

just like in drill down we select any year it shows corresponding all month right like wise.

Thnaks,

Ashok.

[MayilVahanan]

HI

Try like this

Create 2 chart..

1 for "material wise".

2 for remaining

In chart 1 layout properties -> show->Conditional -> Getselectedcount(Materials) = 0

In chart 2 layout properties -> show->Conditional -> Getselectedcount(Materials) = 1

Note: Keep both the chart in the same position and height.

Hope it helps

[sasikanth]

hi,

you can do that one,

Make A drill group , with what ever diemnsions you need,

or else use Calculated dimension for that and group it