how to write dynamic expression

[kunkumnaveen]

Hello all , if i have a sample data like ,how to write a dynamics expression

category  decision      material  lot

smelting    accepted      spix      10

smelting      rejected        spix      20

smelting      exception      spix      30

mining          accepted      hydra      25

mining          rejected        hydra    35

mining        exception      hydra      45

so i need a dynamic  expression :   category={smelting},decision={accepted } and that particular material lot     =       10     in percentage

                                                  category={smelting}   total lot                                                                            (10+20+30)

thanks

naveen

[kunkumnaveen]

  category={smelting},decision={accepted } and that particular material lot    =      10        in percentage           

category={smelting}  total lot                                                                      (10+20+30)

[tamilarasu]

Hi,

Try this

=Num(Sum({<[category]={'smelting'},[decision]={'accepted'}>}lot) / Sum(Total {<category={'smelting'}>}lot), '#,##0.00%')

[kunkumnaveen]

dude i need dynamic expression...see that category and decision  fields i need dynamic ,

what i mean is those fields has to change based up on user selection ,,i just wrote like that for better understanding purpose

[jonathandienst]

Like this perhaps (assuming that this is in a text box or similar undimensioned location):

Sum({<category = {'smelting'}, decision = {'accepted'}>} lot) / Sum({<category = {'smelting'}>} lot)

How do you want to use user selections?

[jonathandienst]

If you mean let the user select a category, then use:

     Sum({<decision = {'accepted'}>} lot) / Sum(lot)

[jonathandienst]

If you mean the user will select both fields:

    Sum({<category = P(category), decision = P(decision)>} lot) / Sum({<category = P(category)>} lot)

    Sum({<category = P(category), decision = P(decision)>} lot) / Sum({<category = P(category), decision>} lot)

[tamilarasu]

Could you post expected output for the above data.?

[kunkumnaveen]

I am showing this requirement in combo chart  

Sum({<category = {'smelting'}, decision = {'accepted'}>} lot) / Sum({<category = {'smelting'}>} lot)

can this expression be a dynamic

Sum({<category = {''}, decision = {''}>} lot) / Sum({<category = {''}>} lot)

those category should change based up on user selection i mean so time it may be smelting or mining or -----------(i got 10 diff values in that filed)

and the same with decision field ..i need that also dynamic

i

[kunkumnaveen]

user will select both category and decision  then it will bring to other chart(combo chart) there material will be dimesion...