Challenge to Experts

[#1]

Table data to be converted in chart.

[tresesco]

See the attached sample.

[#3]

Tresco it do not work for Oct month

[#4]

Any expert have any trick to resolve this.

[tresesco]

See attached. Try to get the logic. You would be able to get it for all scenarios

[#6]

What logic are you talking?

[tresesco]

I expected you to notice some additional scripting. Not an issue, let me explain: If there is no data associated against a field value (like your Months - MARCH, Oct) your stack accumulation would not work. Hence, I added two additional rows in the script:

,,MARCH,Sold

,,Oct, Not Sold

because these combinations were not there before. Then you have to uncheck 'Supress Zero Values' in the presentation tab to make the stack accumulation work properly. Hope it helps you comprehend.

[#8]

Tresco ,

your logic is fine . But what about when there will be plenty of data and plenty of values to the dimension.

[tresesco]

If you can't find a way of populating all combinations(you can think of another table with them), I am afraid that the bar chart with stack accumulation would not work.

[stevedark]

Sometimes appending rows with a WHERE NOT EXISTS statement is the way to go, when you need something for all combinations.