2 Replies Latest reply: Feb 14, 2010 1:19 PM by kkelly RSS

    Sum rows where I only want max amt for dimension combinations

      I need to sum a field 'Patient' for all records for a time period. However, the Patients amount is repeated when there are multiple records referencing the same different combinations of dimensions. In other words, in the example below, I only want to get the max number of Patients (1000) when the record is repeated as follows:

      Date, Patients, Office, AvgCost

      Jan, 1000, XRAY, $2500

      Jan, 1000, XRAY, $10500

      Jan, 1000, XRAY, $5000