5 Replies Latest reply: Jun 25, 2012 12:52 AM by Kiran Rokkam RSS

    Help using cross tables? Or problems with data retrieval from Excel

      Hey,

       

      I have a spreadsheet containing forecasts that I want to compare against sales by month.

      Spreadsheet.jpg

       

      I've then used a cross table to bring it in as that's what I was told I needed to do for spreadsheets of this nature.

      Here is a screenshot of the script

      Edit Script.jpg

       

      And finally this is how the expressions look.

      Expressions.jpg

       

       

      My problem is that some of the item codes are missing the forecast data, while alot of the other products areshowing the right amount.

       

      Eg. Look at FAA and then look at FAA on the top picture of the spreadsheet. There's nothing different about it, but it just won't bring the forecast data through, yet some other items look to work perfectly fine.

      Result.jpg

       

      Can anyone shed some light on this situation?