Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a small req. how we can do this.
value Percentage
100 Logic is 100/1000= 10%
300 300/1000=
500 same
100 same
Total 1000
if in set analysis it might very usefull to learn me.
Thanks ,
Ajay
sum(Value)/sum(total Value)
Ajay
Try something like the attached.
Best Regards, Bill
Thanx Bill.....but user dont want 3 expressions....
Hi Ajay,
Chart Properties, Expressions Enable the Relative check Box. Or try this your expressions Sum(Sales)/Sum(TOTAL(Sales))
You can do it in one expression right like I have written above.
Ajay
If you don't want one of the expressions, then simply delete it.
You probably don't want the one called 'Sum Value', I just put it there to help you understand how it worked, but it seems as if it just confused you.
Best Regards, Bill
Thanks Nicole ,Bill and Raja...Its working.
Thanks Bill for your time more given clarity.
Ajay