I am using following formula to show opening balances please refer formula.jpg for more
=IF(ROWNO()=1,vInvOpn,Above(column(4)))
I am getting correct opening for APR month , but its repeating for every month instead of closing
as opening.
Thanks for help in advance
Regards
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
RowNo() func Returns the number of the current row within each sort group column segment in a table. In case of one dimensional table column segment contains entire column. In case of multidimensional table, there exist multiple column segments and each column segment considers group values of dimensional columns to generate rowno within it.
In your case, seven different segment exist in Pivot chart and each segment contains only on value(e.g. Apr ICY4 for 1st segment). So only 1 is returned by RowNo() func for each row.
TOTAL qualifier makes all the columns as a single segment. Thus RowNo(TOTAL) returns different row position considering one column segment for entire table.
