1 Reply Latest reply on Jan 2, 2019 2:28 AM by Anshul Sharma

    Aggregation affects data download

    Anshul Sharma

      Hui Guys,


      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.