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

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

    Martin Blanchet-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.