How would I accomplish calculating the "weighted" percentage of [$ Amt] for total [$ Amt] for each grouping of [Region] and [Area]? I got as far as
percentage ( [$ Amt] for [Region] ?????
but couldn't get the calculation to accept another filter choice.
Thanks in advance for your help!
Sample data:
Region Area $ Amt Weighted Avg
1 2 564.26 73.78%
1 2 200.56 26.22%
2 2 100.98 33.52%
2 2 200.56 66.48%
2 3 189.56 100.00%
percentage ( [$ Amt] for [Region] ?????
but couldn't get the calculation to accept another filter choice.
Thanks in advance for your help!
Sample data:
Region Area $ Amt Weighted Avg
1 2 564.26 73.78%
1 2 200.56 26.22%
2 2 100.98 33.52%
2 2 200.56 66.48%
2 3 189.56 100.00%