6 Replies Latest reply: Jan 13, 2016 4:58 AM by Nilesh Gangurde RSS

    Unique Row Count

    Kevin Bouwer

      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