8 Replies Latest reply: Jun 1, 2016 8:23 AM by Sunny Talwar RSS

    Iter number dimension

    Андрей Шепель

      Colleagues, good day!

      I have some problem with creating special dimension and work with it^

       

      1.In pivot table i want to create dimension, which must have values from 1 to N (N - value from input box.)

      2. In expression i need get value from this dimension &  '_2016'

       

      For example, if i set value in inputbox 6, i must get sum result pivot report:

       

       

      DimensionGet Value from dimension
      11_2016
      22_2016
      33_2016
      44_2016
      55_2016
      66_2016

       

      test model in attachment.

      Thanks.