Question 1: How can we display both Sales and Profit on the same calendar?
Step 1: Create a parameter for users to switch between Sales and Profit
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture20.png)
Step 2: Create a calculated field to apply the parameter in the view
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture21.png)
Step 3: Put it on the colour shelf
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture22-1024x266.png)
Questions 2: Can we use different colours for Sales and Profit?
Step 1: Create a calculated filed = the Parameter
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture23.png)
Step 2: Put it on the colour shelf
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture24-1024x269.png)
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture25-1024x269.png)
But now we’ve lost our colour gradient…
Questions 3: What is the easiest way to show Sales and Profit in different (gradient) colours?
Step 1: Put the Parameter on the Filter Shelf
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture26.png)
Step 2: Duplicate the sheet, edit the Filter, add Sales in the Customer Value List
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture27.png)
Step 3: Put SUM(Profit) and SUM(Sales) on the Colour shelves respectively
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture28-1024x316.png)
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture29-1024x307.png)
Step 4: Create a new Dashboard, put two worksheets one top of the other with exactly the same Position and Size.
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture30-1.png)