Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.