Bar chart Calculation

[#1]

I am trying to create a stack bar chart.

With table structure

id sta val
1 closed 30
2 fixed 50
3 closed 70
4 new 90
5 open 50
1 fixed 100
3 new 80
5 closed 90

I want the Id on X axis and stacked numerical data ie VAL field depending on there Status(sta)

I am trying to create this one but its not returning me any data on sheet..

Please anybody can help [:(]

[#2]

HI,

See the attached qvw.

Thanks & Best Regards,

Kuldeep Tak

[#3]

thanks Kuldeep for your help