18 Replies Latest reply: Jun 1, 2011 5:36 AM by Onur Civelek RSS

    Pivot Table Problem (not related data)

      Hi everybody,

       

      I have a problem to get the matching objects for the budget (data is not related by the date range):

       

      example.png

      Could somebody help me please to get the correct values in the column "Buget" for

      - 01/2010 --> forecast-value "20" in column "Budget"

      - 02/2010 --> forecast-value "231" in column "Budget"

       

      Attached you can find an example QVW-File and the 3 example-XLS-Sheets.

       

      Thanks a lot.

       

      Regards,

      jup

      ...