Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV,
In the attached sample, I need to show Total as constant even after any value selection in the list box.
Is it possible to show totals irrespective of any value selection.
Suppose
If I select Accenture in the list box, then in the chart I want to display one bar with accenture data and the other bar will display totals of all.
Thanks in advance..
Ananth
Now my chart is not responding to any selections in the list box.
But it should reflect based on selection and grand total remains unchanged
Have you taken two expressions?
No, only one expression is there as I posted in the sample.
Hi
go to chart properties--> dimension limit--> deselect show total.
Now add one more expression shown below.
=sum([Final Rm Rev Result])/sum( [Final Account Rm Rev Goal])
Regards
ASHFAQ
Take two expressions (different) as I mentioned in earlier post when dimension would be [Property Name]
Thank you very much tresesco, Now it's working as I expected
Is it possible to display all the bars if there is no selection.
Now its giving grand total bar and selected value bar.
if there is no selection in the sheet, I would like to get grand total bar along with all the values bars.
Thanks,
Ananth