how to write percentage expression

[kunkumnaveen]

HI, I  am looking for this requirement ,

this requirement is a level 2 requirement  , what i mean is after clicking on level 1 it will bring me to level2

so category and decision filed are selected at level1 based up on that selection the level 2 shows only those supplier which full fill thet category and decision values

level1 dimension:1)category

                           2)decision

expression

=count({$<MaterialName=,YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

level2  dimension:1)name1

                           2)decision

                   expression:1)=count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

                                     2) percentage expression

   count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

/count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1>PRUEFLOS)

i posted this requirement earlier , and some one had replied  me  with the above expression through which he is able to achieve my requirement as seen in below but when i tried using the same expression i am not getting the same out put 

please find my attached test file

[sunny_talwar]

Can you reattach the qvw, I am unable to open it due to error

[kunkumnaveen]

yes ,i will doing it

[kunkumnaveen]

Hello

[kunkumnaveen]

Hello sunny ,

i was trying to attach file from long time ,finally i did now

plz the attachment

[sunny_talwar]

I don't see the charts from the image above in your application. Which object are we working on?

[kunkumnaveen]

i have couple of levels of drill downs i need to write the expression at level3

what i mean is

when u click on level1 both category and decision get selected and it will bring you to level2 where u can see list of materials and again on clicking on any material name at level2 it will bring you to supplier name

so my requirement is to show percentage along with values in that supplier chart

[kunkumnaveen]

i have couple of levels of drill downs i need to write the expression at level3

what i mean is

when u click on level1 both category and decision get selected and it will bring you to level2 where u can see list of materials and again on clicking on any material name at level2 it will bring you to supplier name

so my requirement is to show percentage along with values in that supplier chart

hope u understand the requirement

[kunkumnaveen]

plz any more suggestion and helps to achieve this requirement plzz

[jonathandienst]

Looking at your screenshots, it looks like your expression is working. This will show % per decision for each name1 value. If that is not what you need, perhaps you could define the % you need more precisely.

This will affect the TOTAL <name1> part of the expression. Perhaps you just need to remove the <name1> fragment,