Skip to Content
0
Former Member
Apr 25, 2014 at 07:08 AM

Latest row in crosstab

49 Views

Hello everyone,

I have crosstab like this

1/4/2014 1

2/4/2014 2

3/4/2014 3

4/4/2014 4

SUM <--- this column must be after all month days (sometimes 30,31,28,29)

MAX <--- this column must be after all month days (sometimes 30,31,28,29)

AVG <--- this column must be after all month days (sometimes 30,31,28,29)

I have inserted rows in table which calculate good ( tested on day 30 by inserting empty row after day 30) -> calculation part is good

I need only make formula for insert event for dynamic insert row something like :

if GetRowGroupIndexOf(CurrentRowIndex) = MAX(RowIndex) then true else false or something like this.

any hints are welcomed