Stack chart unable Stack up in one bar ?

[paulyeo11]

Hi All

I have a stack chart work fine in QV :-

it have 2 Dimension :-

year

=if(aggr(sum(sales),SOURCE) / aggr(sum(total <year> sales), SOURCE) > 0.001, SOURCE, 'OTHERS')

and only 1 Expression :-

sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

sales)

/

sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

TOTAL <year

> sales)

Mu issue is when i plot in QS use bar chart , i am not able make the bar stack up in one bar , i can only achieve individual bar stack on X axis.

Enclosed my QVF sample in my next post.

Paul

[paulyeo11]

enclosed my QVF file