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