Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
i have a table with this data:
Year | Total
2001 | 2
2002 | 4
2003 | 6
i put this into a chart table and i need to make an expression on the line 2002 doing the follow thing:
Year | Total | Expresion
2002 | 4 | total2002/Total2001 - 1 = 1
2003 | 6 | total2003/Total2002 - 1 = 0,5
and so forth with a table of many more values
.
how would be this expression?
tnk's,
Yes, right. You probably use a pivot table chart, then?
The chart inter record functions like above(), before() are depending on your dimension values orientation and sort order, so you must pick the right one for your needs (and take care for the case user changes sort order 😉
Try something like
=TOTALFIELD / above( TOTALFIELD ) -1
where TOTALFIELD is the field name which contains your total (or use sum(Value) if you need to calculate your total).
thanks for your suggestion, it was useful for me....
the expression works to me with "before"
total/before(total)-1
Yes, right. You probably use a pivot table chart, then?
The chart inter record functions like above(), before() are depending on your dimension values orientation and sort order, so you must pick the right one for your needs (and take care for the case user changes sort order 😉