Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi need help.
Please find the employee .qvw
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
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
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.
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
Hi,
Try like
Sum(TOTAL {<Employee=>}Salary)
/
Sum({<Employee=>}Salary)
Regards
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)
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
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
hi ankith am nt gettng the chart
i applyied dat expression
result cme lik dis
this is correct. Now go in numbers tab of the pie chart properties and check show as percent(%)
thank u ankit.
its wrkng fine..
Thank you suresh