in the attached workbook i have created a simple bar chart. when i keep the aggregation of the measure to SUM() and do copy->Data then paste it in excel i get the data in the desired format but when i change the aggregation to AVG() and do Copy->Data the the data is sorted in ascending order on measure
if you look at column B in above image quarters ares sorted correctly when aggregation is SUM but the order of the quarters change(increasing order on measure) when aggregation is changed to AVG.
can someone suggest a way to overcome this problem. i am using 10.3 desktop version.