Pivot table row numeration

[Ernests]

Hi, 
I see that there are a lot of similar topics but I can't find solution. 

I have simple pivot table where I have dimension Name and measure count(MyValue) distributed by Months. For each dimension row I need numeration of the row. Also I need this row to be first column of the table. I have tried rowno(), rowno(total) and aggr but nothing works so far, returning just blanks.

Maybe got some ideas?

Thanks.

[Or]

At least for a basic pivot, aggr() should work. In this example, I used aggr(RowNo(),Dim):

[Ernests]

Thank you for reply. 

I tried that also but it excludes some numeration, for example, 10th, 20th, 29th (see image below) but in filter I still can see it.

And since I use aggr, numeration does not change when filters are applied.

[Or]

This approach should respond to filtering on fields in the app (at least, it is on my end). I believe you can use it to filter on the dimension, but keep in mind the row numbers are never going to be consistent across iterations since they are re-calculated each time you filter. This approach shouldn't skip anything unless you are hiding zero/null rows.

[Ernests]

Problem seems to be related to my data model. In case where all the values are taken from the same table numeration using aggr is possible.

Thanks anyway!