1 2 Previous Next 16 Replies Latest reply on Mar 7, 2011 11:07 AM by Allen Spurgeon

    Need help with building distinct value calculations

    Allen Spurgeon

      I need to build calculations that will sum values into a total and grand total field. I can display the distinct values for each report line item, but I do not know how to show the correct subtotals. If my distinct line items have duplicate values, the subtotal calculation will sum(distinct value of all line items) instead of sum( line item value).

       

      Attached is an example of my underlying data and how I want to display the data.

        1 2 Previous Next