10 Replies Latest reply: Jun 8, 2015 5:02 AM by Ankit Mishra

# RE: pie chart

hi need help.

and revnenue sheet employee sheet.

the reuirement is

dere are bar chart and pie chart and employee filter

if i select any of employee it wil reflect only in pie chart nt in bar chart

give the suggestions.

thank you suresh

• ###### Re: RE: pie chart

Hi,

Change your bar chart expression like this.

sum({<Employee=>}salary)

If u select any employee now, u will see change only in pie chart and not bar chart.

• ###### Re: RE: pie chart

tank you ankith its wrkng fyn.

but one more thing i want to disply in pie chart as if v select A in pie chart result vil b

a

value 100

nd % also... means  sum(total)/A like

Thnk you

suresh

• ###### Re: RE: pie chart

Hi,

Try like

Sum(TOTAL {<Employee=>}Salary)

/

Sum({<Employee=>}Salary)

Regards

• ###### Re: RE: pie chart

Not sure exactly if u want this.

change your pie chart expression like this and let me know if you want this

sum(salary)/sum(TOTAL salary)

• ###### Re: RE: pie chart

please find the image that vil b the result witout selectng any filter  pie chart wil display % of A and B and C

means A/sum(total).

thanks

suresh

• ###### Re: RE: pie chart

Use the expression I have mentioned above in the pie chart. It fulfills your requirement.

sum(salary)/sum(TOTAL salary)

Also in numbers tab tick Show as percentage

• ###### Re: RE: pie chart

hi ankith am nt gettng the chart

i applyied dat expression

result cme lik dis

• ###### Re: RE: pie chart

this is correct. Now go in numbers tab of the pie chart properties and check show as percent(%)

• ###### Re: RE: pie chart

thank u ankit.

its wrkng fine..

Thank you suresh

• ###### Re: RE: pie chart

cheers...!!!