Excel File/Cross table help

[apthansh]

Hi - I have attached excel file and QVW ...I have one chart in the qvw but I want another Bar Chart Actual Savings by Year with

toggle by Year, show 2 bars per year (MTMActualSavings and PSOActualSavings)

Is it possible.Any help is appreciated.Thanks much.

[dplr-rn]

if i understand your issue correctly create a bar chart with 2 dimensions year, initiative

and if you want only those 2 initiatives use set analysis

sum( {<Initiative={'MTMActualSavings' ,'PSOActualSavings'}>} [Actual Savings])

[apthansh]

Thank you but That will not work as I have different year columns.

[dplr-rn]

Can you explain in more detail?