Sum of Max values with different dimension

[Shahzad_Ahsan]

Hi

I have data like this:

Category	Value	READING_DATE
A	193.7599945	01-Nov-2019
B	782.4899902	01-Nov-2019
A	193.3899994	01-Nov-2019
B	782.4799805	01-Nov-2019
B	782.4299927	01-Nov-2019
A	192.8999939	01-Nov-2019
B	782.4299927	01-Nov-2019
B	782.3800049	01-Nov-2019
B	782.3800049	01-Nov-2019

I need to create expression which gives Sum of Max Value with different category

Expected Result:

Value	READING_DATE
976.24	01-Nov-2019

[Lisa_P]

[Shahzad_Ahsan]

Hi Lisa

Thanks for your reply.

I have used this, this is working fine for test but not on my live Data.

I have attached my QVF please have a look.

In Line chart there is drill down By month , date and Time. 

I need the Sum of Max values with different categories.