How do I display the bell curve for overall count?

[Anonymous]

Here is the example attached. Please help me.

[sunny_talwar · Accepted solution]

May be like this:

Sum({1<%VisitType={'NPV'}>}%ProcedureCNT)/Sum({1<%VisitType={'NPV'}>}Total %ProcedureCNT)

[sunny_talwar]

Or this if you just want to ignore selection in Department

Sum({<%VisitType={'NPV'}, Department>}%ProcedureCNT)/Sum({<%VisitType={'NPV'}, Department>}Total %ProcedureCNT)

[Anonymous]

This works for me. I did new that I have to use "1". But did not know where! Pretty Tricky!

Thanks for your help

Pavithra Shetty