Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is probably very simple for someone. My rowno() function is showing 1 for every row.
More detail:
I have a straight table with several dimensions and expressions and am trying to get a running total for sales. I first tried to accumulate the sales and it works when changing to a graph but not in data form (straight table). So I decided to try rangesum and above functions which did not work. So I tried rowno() and see that every row shows as 1. This is obviously why it is not working. Any ideas why the rows are not recognized as a unit?
Because each row is unique to the dimensions. If you want a running total, then use:
RowNo(TOTAL)
That gives the row number ignoring the dimensions.