Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 10, 2022 3:23:50 PM
Oct 24, 2017 4:52:37 AM
When using RowNo to count the number of rows on a Pivot Table, it doesn't seem to work because the count starts again somewhere in the middle of the table (see below),
The expected result is shown below.
Environment:
The issue occurs because RowNo() returns the number of the current row within the current column segment in a table, that is the count starts again from 1 each time the value of the first dimension changes.
To get the desired result we have to use the TOTAL qualifier in the RowNo() function as shown below.