0 Replies Latest reply: Oct 3, 2016 12:33 PM by Kyle Roberts RSS

    Percentage of Row for each Column

    Kyle Roberts

      I am trying to get the Percentage for each week of the month. So in each month the weeks should add up to 100%. Right now it is taking the total of everything. If you select one month it works just fine. Any thoughts?

       

      Sum({$<[DETAIL_TYPE] = {1,10}>}AMOUNT)/Sum(total{$<[DETAIL_TYPE] = {1,10}>}AMOUNT)

      12457.JPG

       

      Below is what I want to see but not filtered on just one month.

       

      4545453.JPG