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, valuegroup1, team1, 5group1, team1, 10group1, team2, 5group1, team3, 1group2, team1, 100group2, team2, 500
i want this in a pivot as output
group, min team, max team, min value, max valuegroup1, team3, team1, value_team3, value_team1group2, 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?