1 Reply Latest reply on Mar 3, 2016 3:45 AM by Chris McClellan

    Issues creating a line chart from a table using LOOKUP

    Nicola Boorman

      Hi all,


      Really stuck and no idea what I am doing wrong! So I have the data that I need in tabular format.


      The data is a summary of YTD savings by month/year and performs a lookup to determine how much is carried forward from the previous year.




      I then want to plot this in a line chart and when I try I get a message saying "the table calculation requires a field that is missing, please add to the view". I have been messing about with this for a day and when I do manage to get a line chart it then has the balance carried forward from the previous year missing - in other words, the lookup calculation no longer works.


      Can anyone help?