1 Reply Latest reply on Apr 26, 2017 4:00 AM by Mavis Liu

    how to change agg value to sum

    Linas Sutkaitis

      Hi,

       

      I think someone had this problem before, how to change aggregate value to sum. I have two fields which I want to put in a column and Row position and show it as a graph, but because the values are aggregated the graph doesn't show anything. Maybe someone knows hows to change it to SUM?

       

      Thank you.

        • 1. Re: how to change agg value to sum
          Mavis Liu

          Hi Linas,

           

          Could you provide us with more information on the particular fields you're trying to sum or attach the workbook that you are working on? Just as a side note, you cannot sum an agg because it has already been aggregated and which means it cannot be aggregated any further. You can remove the aggregation however by going to the 'Analysis' at the top of the worksheet and unticking the 'Aggregate Measures'.

           

          Thanks,

           

          Mavis