AnsweredAssumed Answered

Chart Record Data from Different Fields

Question asked by bleyden on Jun 13, 2018
Latest reply on Jun 13, 2018 by bleyden

I want a chart that will show me the projected revenue for each month in a given year.  I have months 1-12, a UnitsSold and UnitPrice for each month, and a revenue for each month.  All of these fields are on my Forecast table.  How can I get all 12 revenue fields shown on the chart?  Do i need to create a hidden field that will put the data entered in each individual field in a text field to create a delimited field?  And, if so, how do I go about that?  Any thoughts are greatly appreciated!