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.