Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kroberts13
Contributor III
Contributor III

Percentage of Row for each Column

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

0 Replies