In waterfall chart the offset is defined as follows:
= if (GetSelectedCount(Phase_Level_Txt) = 1, 0,
if (rowno(total) = 1, 0,top(total Counter)- rangesum((top(total Counter,2,rowno(total)))))
Can anybody please explain what it does and how it positions the columns?
In particular I am interested in this part of the code:
The probelem does not seem to be the OFFSET, because it seems it calculates it correctly.
However, I can't find explanation why the chart positions first 5 (6) columns correctly, and then inserts the gaps between the two last columns taht have values 501 and 2 respectively. (please look at the picture below)