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



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



      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.




      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.



      Can anyone shed some light on this situation?