I'm creating a report definition with columns for a Location, Pay Item number, and Quantity. Then I'm creating Calculated columns for each Pay Item that I'm specifying and using an expression to put the associated quantity into that column. From here, I would like to Group everything together by location only, hide the Pay Item number column, and sum the calculated columns. However, this does not work because the expressions used to place the quantity in the calculated column does not solve if the column with the item number is not there.

I would like an enhancement for this issue to be resolved so I can group by location without breaking the columns with the specified pay item. My idea would be to allow this kind of function without the use of a calculated column. If we could add multiple columns for the "Quantity" and then add a filter so that column only shows the quantity if the "Pay Item" item type property displays a certain value. This would remove the need for any expression and should allow for grouping based on the location.