0 Replies Latest reply on Jan 2, 2019 2:05 AM by Anshul Sharma

    Aggregation affecting Download

    Anshul Sharma

      Hi 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.