Sum rows where I only want max amt for dimension combinations

[#1]

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

[Oleg_Troyansky]

If I understand you correctly, you need to use an Advanced Aggregation function ARRG(), to calculate max amounts by Date and Office, and then summarize the results:

= SUM( AGGR( MAX(Patients), Date, Office))

[#3]

Awesome...that worked! What if I wanted to show that aggregate on every row in a table?