Is there a way to group my front end expression ?

[that_anonymous_guy]

A	B	C
5	5	Team1
7	5	Team1
3	7	Team1
8	3	Team1
4	8	Team2
6	4	Team2
8	6	Team2

Column B is fetched using above() function i.e above(A) and to get the first entry as A rather than '-' I have clubbed it with coalesce function as coalesce(above(A),A). Now the problem is that I want to group the expression that I'm using team wise so that I can have the data as mentioned in the table below

A	B	C
5	5	Team1
7	5	Team1
3	7	Team1
8	3	Team1
4	4	Team2
6	4	Team2
8	6	Team2

So in simple terms I want to group it team wise. Is there a way I can achieve this?

[SerhanKaraer]

Hello,

You can add team check in the expression as below:

=if(RowNo() = 1, Only(A),
	if(Only(C) = Above(Only(C)), Above(Only(A)), Only(A))
)

I hope it solves your problem.

[vinieme12 · Accepted solution]

As below

=If(C=Above(C),Above(A),A)

[that_anonymous_guy]

yes it's working..we just need to add total total keyword to it..thanks