looking for change in expression

[kunkumnaveen]

Hello

my requiremnt is to show % of each decision filed value of same supplier ,to achieve this in a bar chart

  i took dimension: 1)name1        //(supplier name filed)

                            2)decision    //(accepted,rejected,exception)

and expression i wrote is:

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

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

so problem is  while i am showing all the supplier i am getting different values

but if i choose one supplier then i am able to get  what i am looking

this is what i am looking ,so i think i need to do a changes in my expression ,any one suggest me what changes should i need to do plz

[Kushal_Chawda]

can you try this

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

/sum(aggr(count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS),name1))

[kunkumnaveen]

No luck,its not working

[Kushal_Chawda]

try to add decision as well in expression

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

/sum(aggr(count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS),name1, decision)

[kunkumnaveen]

i did add Decision ,but it says NO DATA TO DISPLAY

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

/sum(aggr(count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS),name1, Decision)

[kunkumnaveen]

Any helps or suggestion to achieve this task plz

[Kushal_Chawda]

can try this or post the sample application so you will get the quicker answer

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

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

[kunkumnaveen]

yes i will try  to post my sample application,but it is about 13mb  so plz gives me few time to upload it

[sunny_talwar]

Would you be able to share your application?

[kunkumnaveen]

Hello plx find the attachment