RaviWildcat
Board Regular
- Joined
- Jun 18, 2010
- Messages
- 119
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi everyone, I've got a question about charts:
Background:
There are 5 cities I am tracking. I've created a separate graph for each one. Atlantic City, Bayonne, Hoboken, Jersey City, and Newark
There are 3 users, Greg, Marcia, and Mike
Greg can see data for Atlantic City, Bayonne and Hoboken
Marcia can see data for Jersey City and Newark
Mike can see data for all 5 cities.
So - I'm creating a page where -
At the top of the screen select a user (Greg, Marcia, Mike)
Show the graphs for the cities associated with each user.
I've figured out how to display the data based on which user I select (I'm using a series of helper columns and indexes)
However!
If a user selects Greg, I only want to see 3 charts. If a user selects Marcia, I only want to see 2 charts and if a user selects Mike I want to see all 5 charts
Is this possible?
Thanks,
Ravi
Background:
There are 5 cities I am tracking. I've created a separate graph for each one. Atlantic City, Bayonne, Hoboken, Jersey City, and Newark
There are 3 users, Greg, Marcia, and Mike
Greg can see data for Atlantic City, Bayonne and Hoboken
Marcia can see data for Jersey City and Newark
Mike can see data for all 5 cities.
So - I'm creating a page where -
At the top of the screen select a user (Greg, Marcia, Mike)
Show the graphs for the cities associated with each user.
I've figured out how to display the data based on which user I select (I'm using a series of helper columns and indexes)
However!
If a user selects Greg, I only want to see 3 charts. If a user selects Marcia, I only want to see 2 charts and if a user selects Mike I want to see all 5 charts
Is this possible?
Thanks,
Ravi