Need help on filtering Data

[#1]

Hi Qv,

I have a bar chart and straight table in my dashboard.

Please find attached, In this I'm getting Revenue properly but problem is with the Goal.

I have verified source data, charts are displaying Goal more than the actual Goal present in the source file,

Could you please help me out from where it is picking up the goal.

Thanks,

Ananth

[m_woolf]

When I load the Excel data from Goal.xlsx into a new qvw and chart it, I get the correct total for YTD Goal for Shanghai Sales of 50,688,328