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
