Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
would you please help me to show the percentage of the stack bar chart with percentage by dimension?
if i just check the check box 'value on data points' and 'relative' , it will show percentage, but it is not related to the dimension by month, the whole year is 100%. but i want to make 100% by month.
thanks for your kind help.
Manie
Or that?
My proposal for you
Dear Enrique,
Thanks for your prompt reply.
However, i want to show the QTY value like 20, 40, 60, 80, 100 on the Y-axis, then on the bar chart , should be 100% in Jan, 100% in Feb, in Mar, A should be 42% and B should be 58%.
thanks,
best regards,
Manie
Yes, ¿now?
Dear Enrique,
it doesn't work if the total quantity isn't equal to 100, so you can't just divide 100....
P.S. i don't know how to upload QVW in the reply section... so i didn't attach the QVW...
thanks,
best regards,
Manie
To attach a file you need select in the corner up in right (avanced editor) and then you have the option to upload a file
In the expression:
Sum(Qty)/Sum( TOTAL <Month> Qty)
And Number select %
Dear Enrique,
it works on your simulation, but i try, it didn't work on my dashboard.
Please find the attachment, i have make it a little bit complicate:
we need to show two groups of product in legend: 'top 3 product' as one group and the others exclude by top 3 belongs to 'others'
and the top 3 product is base on monthly sales, not yearly sales, which means the top 3 customer in Apr, is based on Apr's QTY, not whole year's QTY.
it should looks like this:
so would you help?
thanks,
best regards,
Manie
Now?
Or that?