Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All
I have a stack bar chart , the bar display the actual sales value . So the bar some are high and some are low.
My aim is to make all the bar same height , so i am able to view which is the high contribution % Exp from year by year changes.
I aware that the code should look some thing like below :-
=if(aggr(sum(sales),$(ColumnDim10)) / aggr(sum(total <$(ColumnDim_p)> sales), $(ColumnDim10)) > 0.001, $(ColumnDim10), ' Other')
But i am not able to apply here.
Hope some one can share with me.
Paul
Enclosed my QV Doc
Can't look at your example yet as I'm doing a reload.
Sounds like you want to show the relative proportions of the primary aggregation, split by a secondary dimension.
Have you tried ticking the Relative checkbox on the expression ?
Jonathan
There is a graph exampe on my website that shows all bars the same size. It may help you. See here:
Hi Rebecca
nice link , me like those creative art. Thank
Hi All
Can some one share with me.