How to show the difference between categories and the selected category with parameter actions

0:00
/

Using Sample-Superstore data source I'm going to walk you through how to create a chart where if you select a category the other categories are compared to the selected one.

Step 1. Create a parameter based on the Sub-Category field.

Step 2. Create a field to get the sales for the selected Sub-Category. ('Selected Subcategory Sales')

Step 3. Create a field to fix the total sales of the selected Sub-Category. ('Selected Subcategory PA')

Step 4. Create a field that calculates the difference between the selected Sub-Category and the other Sub-Categories. ('Difference of sales between subcategories')

Step 5. Put Sub-Categories on Rows, 'Difference of sales between subcategories' on columns.

Step 6. Set up the parameter action that allows the selection of Sub-Categories.

Voila:

Author:
Linda Duong
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab