13 Replies Latest reply: Apr 7, 2014 5:40 AM by ramarajan M RSS

    Column no/row no as dimension in pivot table

    Britt Jacobs

      Hi all

       

      I have the following pivot table. I want to add the red values as calculated dimension (these values are the number of the columns), but I'm not able to do that. Is there any function which I can use? Loading the rowno in the script is not a possibility.

       

      Country

      012014

      1

      022014

      2

      032014

      3

      country1200300400
      country2300400500

       

      Thank you in advance!