Water Fall chart Direction

[#1]

Hi All,

Currently I am getting a water fall chart bottom to Top as shown follows. Actually I Require Top to Bottom. I am using the expression in Bar Offset is "=sum(total [Value]) - sum([ Value])- rangesum(Above(sum([Value]),1,RowNo()-1)) " and in chart expression is  sum([Value]).How can change this bars direction to top to bottom instead of bottom to top?

Thank you All

[Anonymous]

Just add the same expression you use in the chart  in the calculated expression in order tab,  and select descendent order.

Marc.

[#3]

I require this w r t Dimension.Dimension Order has been changed. Actually Previously I used that calucated expression in the sorting for a dimension

[#4]

Its working after multiplying Bar offset expression with -1

Thank you

Ramgopal

From: Bollimultha, Ramgopal

Sent: Wednesday, October 22, 2014 10:16 PM

To: 'jive-991354505-3bof-2-dpq1@qliktech-public.hosted.jivesoftware.com'

Subject: RE: - Water Fall chart Direction

I require this w r t Dimension.Dimension Order has been changed. Actually Previously I used that calucated expression in the sorting for a dimension