2 Replies Latest reply: Oct 15, 2015 6:35 AM by jagan mohan rao appala RSS

    Percentage calculation by Set Analysis

    Martha Cabrera

      I have this

       

      Percentage calculation.png

      And the Mesure is calculated by

       

      Sum(SaleAmount)/SUM(total SaleAmount)

       

      But what I really want is that each category has its own 100%, and not the 100% of all the categories

       

      Does anyone knows how to do it by Set Analisys?

       

      Thanks

       

      MAC