Totally agree on that. Additionally increasing the number of fields that can be referenced from 5 to 10 fields (or even more) would help me a lot!! Otherwise I would need to compile the report in another tool..
Trying to get average price dashboard, I'm unable to get it done. I have the tonnes * Price per tonner = $Gross Sales, but I'm unable to Use Summary Row Total of Gross Sales and / it by the tonnes to get weighted average price per ton