Hi,
the table looks like this:
| Key1 | Subkey | Value | String | ID |
|---|
| 100 | 1 | 5 | null() | 1 |
| 100 | 2 | 3 | Stringtostartfirstsum | 2 |
| 100 | 3 | 7 | null() | 3 |
| 100 | 4 | 1 | Stringtostopsum | 4 |
| 100 | 5 | 3 | Stringtostartsecondsum | 5 |
| 100 | 6 | 5 | null() | 6 |
| 100 | 7 | 3 | null() | 7 |
| 100 | 8 | 2 | Stringtostopsecondsum | 8 |
I want to do something like "sum all Values with Key1 where ID >= Stringtostartfirstsum and ID < Stringtostopsum, Table is already ordered and Key1 is dimension. In excel I would say subtotals...
Is it possible to sum the values in the chart via set/if expression or do I have to flag the values in script?
.png "Luminary Alumni"){kind=icon}
