Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to know What is the difference between Above and Before in chart?
I have line chart
Dimension is A
1st Expression is Above(Sum(B)) /// it is working
2nd Expression is Before(Sum(B)) /// it is not working
My qus is Y?
Regards,
Kabilan K
hi
Before() function returns NULL in all chart types except pivot tables, bcoz. Before() function use for the column before the current column within a row segment in the pivot table only.
in case of Above() function use for the values as they appear on the row above the current row within a column segment in a table.
On the first row of a column segment a NULL value will be returned, as there is no row above this one.
I think u r using in charts. In chart before() didnt work. Its only work on Pivot table.
for before() it gives the before row value.
Above() function gives the above value of the field value. The first value returns NULL.
Regards,
Khadeer
Thank U Guys...........