Chart with Actuals for Current and Previous Year but Budget only for current year

[former_member597410]

Hi

I have a chart requirement where i am supposed to show Actual Gross Profit Jan - Dec for current year vs budget vs previous year.

If i select previous year, the chart starts showing Budget for previous year as well, which is irrelevant.

In the attached image i would also liek to add a bar for actuals for previous year.

.

Can you please suggest a way to exclude Budget for previous year?

[JamesRLongstaff]

Hi Uzair,

Import the data to SAC as different versions for actuals 2019, budget 2019 and the actuals for 2018 should be created as a third version, which can be a forecast. This will either involve overwriting the data you already uploaded or creating a new model, which ever turns out easiest.

I am assuming the possibility of creating an import data model.

Hope this helps.

Regards

James

[former_member234401]

You would need a planning License for that