2 Replies Latest reply: Jul 10, 2013 8:44 AM by Johan Ohlsson RSS

    Input box problem

      Hi,

       

      Does someone have any suggestions or better ways how to use input box variables and display them in a table or pivot table so they matches selected dimensions inside the table?

       

      I have a table like this:

       

      Region  Month Actual

      North     1              20

      North     2              25

      North     3              30

      South     1             10

      South     2             15

      South     3             10

       

      Want to do something like this:

       

      Target (Input box)

      North_1    Variable(ex.10)

      North_2      Variable(ex.15)

      North_3      Variable(ex.20)

      South _1     Variable(ex.5)

      South _2     Variable(ex.10)

      South _3     Variable(ex.15)

       

      Region  Month Target Actual

      North     1           10      20

      North     2           15      25

      North     3           20      30

      South     1           5       10

      South     2          10      15

      South     3          15      10

       

      Thanks

       

      -Johan