Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Awesome...that worked! What if I wanted to show that aggregate on every row in a table?