I created a Dashboard to compare the sales of 2 regions. I wanted to add a pie chart to the Dashboard. But the pie chart shows percentages for all regions. Here is the situation:
- I created Primary Region and Secondary Region parameters and calculations to use for the filtering actions.
- On the Dashboard, the filtering is done using the parameters NOT the "Apply to Worksheets > Selected Worksheets" function.
- I am not using the Dashboard > Actions functions either.
OBJECTIVE: When the filters (parameters) for Primary Region and Secondary Region are selected on the Dashboard, one pie chart would automatically display Primary Region and Secondary Region data as separate slices without the user having to use Multiple Values List functions.
My question is: On the Dashboard, how do I make the pie chart automatically display region data when the parameters filters are selected? For example, when I select the filter (parameter drop down) "West" for Primary Region and "East" for Secondary Region, the single pie chart would display a slice of West region data and a slice of East region data.
Do you think I will need a calculation for a filter? If yes, kindly please share it.
On the Pie Chart sheet, I am able to use Multiple Values List functions to manually select and view region data. The Multiple Values List function is NOT what I want on the Dashboard.
Any help is very much appreciated. Thanks in advance.
If this has resolved your question could you kindly mark "select as best" to close the question? Thanks
The calculations are mainly thinking about "what would I need to do?" There are gazillions of tutorials etc but in this case, the calc itself is very easy, it is more about thinking what you need to do to your data to achieve the intended result.
You may check out jimdehner.com and his zero to zen series
eric parker with 1number has great beginner friendly tutorials on youtube.
tutorialspoint on youtube also has basic stuff available.
there is an endless source but in most cases, you will need to derive what is needed for your specific use case.
