6 Replies Latest reply: Oct 7, 2011 9:30 AM by Martin Pedersen RSS

    Logic to show other figures than selected and the dimensions in table

    Martin Pedersen

      I need to create a Pivot table that shows the Sales and the Sales from last TimePeriod. In the table I have the Time Period as a dimension and I need to be able to select specific time periods in list boxes.

       

      The problem is illustrated like this:

       

      Current Selections:

      Period: 22

      Week: 01

       

      Pivot Table:

      Period & Week; Sales; Sales Last Period

      2201; Sum(Sales); Sum(????)

       

      I need to figure out what to put in the formula with the question marks. Further I have attached a simple document to illustrate the problem.

       

      Hope that someone can help me with this issue - and let me know if I should provide more details.