Analytics Software

Hi All,

We have a requirement regarding the sorting of set of bars in the Graph.
The Bar Chart shown in the attachment, have a

Dimension column(X-axis) : "Status",
Series column : Date &
Fact : "No. Of Units".

[http://s1055.photobucket.com/albums/s504/sracha/?action=view&current=Example.jpg]

I want these set of bars for each status record in descending order in terms of their value but not by series row names.


Eg:
Consider the value "Closed" on X-Axis.The "Date" series bars in the "closed" record should come in descending order ( in terms of value).
Same with other records of "Status".

Please note : This requirement should be achieved in 11.5 & in pivot table graph.

Thanks for your help.