i'm struggling to sort the chart based on percentage value in a water fall chart. please find the application attached which has the requirement explained properly
These are within different expressions. I am not aware of a way to do this. I am curious to know if there is a way or if there is a work around available.
actually tried different things like use only one expression and using dimension Cat but we need a waterfall chart with sort as per mentioned in the attached application
Ya I played around with that idea of using Cat as your dimension. But then bar offset won't be possible (or if possible would be one heck of a job) + another issue I ran into was the total. So not really sure how you can do this, but all the best.
