I'm looking to compare a single Fortune 500 company's revenues (selected by the end user from a list of all Fortune 500 companies) to an average revenue for all Fortune 500 companies over time. I would like the averages to show up as bars and the single company revenues to show as a line graph (both on the same chart).
I understand how to set two different chart types on the same view. What I don't understand is how to write the calculations and parameters to give the end-user the functionality of choosing a single company and comparing it against all others.
Any suggestions on how to do this? Happy to clarify further if needed.
Thank you in advance!