Connect to the "Global Superstore" data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?
Drop the Product Name to the filters and Select Top 10 based on Sum of Profit.
Drop the Product Name to the Rows and Profit to the Text.
Drop the Market to the filter and select the Europe.
Your view will look like this:
Here, you are getting only 9 products.
Add Market filter to the context so that the Product Name dimension filter will be executed
after the Market filter.
View:
Jacklyn
10 months agoKerrie
9 months agoAshton
9 months agoElenore
10 months agoTayna
9 months agoOzell
10 months agoGeorgene
10 months agoBeula
10 months agoKyoko
9 months agoDelfina
10 months agoDick
10 months agoDeonna
10 months agoKeneth
11 months agoFlorencia
10 months agoAndrew
10 months agoCarlee
10 months agoAshton
10 months agoCory
10 months agoNickole
11 months ago