Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Just add the same expression you use in the chart in the calculated expression in order tab, and select descendent order.
Marc.
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
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