how to display 2 different KPI on the same bar chart

[#1]

hello dear members,

I have below set of data:

Company	ItemCode	PeriodYear	PeriodWeek	Sales in Week - 1	SalesForcastInWeek0	SalesForcastInWeek1	SalesForcastInWeek2	SalesForcastInWeek3	SalesForcastInWeek4
CompanyA	XYZ1	2016	1	30	40	40	30	30	50
CompanyB	ABC2	2016	2	60	70	70	60	60	100

When User selects any combination of  company + itemcode + periodYear + periodWeek, then user would like to see on the same bar chart as follows the fields renamed as:

Could you please help?

[Gysbert_Wassenaar]

Why don't you rename the fields in the script?

LOAD

     ...some fields...,

     SalesForcastInWeek-1 as [Week-1],

     SalesForcastInWeek0 as [Week0],

     ...etc