Sum max values from a table and display in digital gauage

[#1]

I have a table that displays only the max values from a data set and I would like to display the total of those max values in a digital gauage. However the digital display will sum all data points for the first line item in the table, or it will display only the max value and not sum the other values in the vertical column.

Any ideas as I am new to this?

Obviously this would adjust once items are selected or deslected.

Small subset of data:

group_name	Only (group_power)	Only (group_temp)
B01	1896	90.05
B02	5031	90.95
B03	3337	90.05
B04	3372	93.65
B05	3968	85.55
B06	2579	90.5
B07	4121	90.95
B08	1848	94.1
B09	4848	97.7
B10	5182	98.15
B11	6106	102.2
B12	5509	97.25
B13	4966	102.2
B14	5652	92.75
	58415

[#2]

If you wan the aggrgation in the gauge, include the corresponding function in the expression.

An example: sum(aggr(max(Group_Power),Group_Name))

--Arun

[#3]

Thank you for the reply. However when I use the example above it does not display a value other than 0 (zero).

Any other ideas?

[#4]

let me take back the previous comment. It does display a value but it does not calculate the total values of the selected, it only display the first selected value.

[#5]

Zero even if you select a/multiple groups? I have a similar example which is working fine:

sum(aggr(max(Group),Cost)) where bothe Group and Cost are dimensions/fields.

--Arun

[#6]

Thank you... I got it now.

I did not have both defined as dimensions.

Your help is greatly appreciated.