Unique Row Count

[#1]

Hi There

I am looking to get a unique row count per calculated dimension in a Pivot Table

This is how I want the data to be represented

I have attached the raw data

Period, Row Number

Innings.1      1

                     2

                     3

                     4

Innings. 2     1

                     2

                     3

                     4

                     5

                     6

Innings. 3     1

                     2

                     3

Thanks

[Anonymous]

What issue you are facing while doing same??

[#3]

Hi Balraj

Thank you for your response

I want to know the number of rows per innings and not the total row count

I get the data as follows in the Pivot Table

Period, Row Number

Innings.1      1

                     2

                     3

                     4

Innings. 2     4

                     5

                     6

                     7

                     8

                     9

Innings. 3     10

                     11

                     12

[tresesco]

Have you tried RowNo()?

[nilesh_gangurde · Accepted solution]

Please find attached qvw file.

Regards,

Nilesh

[#6]

Thank you Nilesh

It works

Much appreciated

[nilesh_gangurde]

Please mark the post as answered.

Regards,

Nilesh