Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have this pivot:
dimension : group,team
expression: sum(value)
data:
group, team, value
group1, team1, 5
group1, team1, 10
group1, team2, 5
group1, team3, 1
group2, team1, 100
group2, team2, 500
i want this in a pivot as output
group, min team, max team, min value, max value
group1, team3, team1, value_team3, value_team1
group2, team1, team2, value_team1, value_team2
how can i do this?
min(aggr(Sum(Bedrag), Group))
ok .. this works .. but how do i get the coresponding teamname with this output?