This content has been marked as final.
Show 1 reply

1. Re: How do i get the SUM of Averages with respect to a particular Field?
Shawn Wallwork Mar 3, 2012 12:21 PM (in response to Archana Amarnath)Archana, I think the attached workbook is what you're looking for. I changed your formula from AVG() to SUM() and it produces the numbers the same as your spreadsheet:
Then use the subtotals to show the category % discounts:
By the way, I'm pretty sure what you wrote here:
Eg: For SKU 1, Discount Rate= 25.43%, whereas we need it to be 1.92% (Refer to Excel Sheet for
...is a typo. It is 4.09% not 1.92%, right?
Also, if you take the Regions off the row shelf you'll get the correct totals for each SKU:
Hope this helps,
Shawn

Trial 1SW.twbx.zip 83.2 KB

Dummy data_1SW.xlsx 109.8 KB
