Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using RowNo() Every Row shows 1

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?

1 Reply
Not applicable
Author

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.