i have a table with serveral datasets (rows) for each day
i need a slice with 2 datasests (rows) for each day:
a) 1 row with min-value of a specific numeric field for each day and
b) 1 row with max-value of the same numeric field for each day
i know that i can achieve Min- and Max-vaues with expression: MAXROW() and MINROW()
but i dont find a solution for selecting only 1 max-row and 1 min-row for each day …
many thanks in advance for your help.
Gottfried SUDI
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |