Cummulative Ratio in Bar Chart with multiple Dimension

[swatitomar]

Hello All,

I want to calculate ratio i.e. Cummulative claim/cummulative wholeale with multiple dimesnion that is Model and yearmonth in bar chart..

when i select sinlge Model from list box then value comes ok but when i select multiple brands then its not working fine...

Its working ok in Pivot Table(with before() ) but when i tried in line chart(with before() ) its showing wrong value..

=(rangesum(Above(total count(claim_no)0,24))

/
rangesum(Above(total count(wholesale),0,24)))*100

please help....

thanks in Advance

Swati

[sunny_talwar]

It must be because of the sorting difference. Would you be able to share a sample showing the problem your facing?

[swatitomar]

Yes Sunny you are right that was bcoz of sorting issue..

I correct it now its working ok..

Thanku for suggesting ..

[sunny_talwar]

Awesome

Would you be able to close this thread by marking correct and/or helpful answers?

Best,

Sunny