% calculation(:-)

[ajaykumar1]

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

[Nicole-Smith]

sum(Value)/sum(total Value)

[Anonymous · Accepted solution]

Ajay

Try something like the attached.

Best Regards, Bill

[ajaykumar1]

Thanx Bill.....but user dont want 3 expressions....

[#5]

Hi Ajay,

Chart Properties, Expressions Enable the Relative check Box. Or try this your expressions Sum(Sales)/Sum(TOTAL(Sales))

[Nicole-Smith]

You can do it in one expression right like I have written above.

[Anonymous]

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

[ajaykumar1]

Thanks Nicole ,Bill and Raja...Its working.

Thanks Bill for your time more given clarity.

Ajay