Thursday 7 May 2015

Top 10 and Bottom 10 values by Sales

1) First you create a set for top 10 Products by Right click on a product field-> then create a set -> then select "Top" ->  then define "10", choose "Sales"  with sum.


2) Create second set  for create Bottom 10 Products by right click on a product field -> create a set -> then select bottom -> then define 10, choose sales with sum


3)  now combine the first and second set, by clicking on any one of the sets and -> selecct combine set -> select all values 

4) First drag the sales in to rows shelf, and then Products in to columns shelf.


5) Now drag the combine set in to the filter shelf... now your view will have only top 10 and bottom 10 values by sales.

4 comments:

  1. I've just decided to create a blog, which I have been wanting to do for a while. Thanks for this post, it's really useful!
    10etext

    ReplyDelete

  2. Thanks for sharing valuable information. Your blogs were helpful to tableau learners. I
    request to update the blog through step-by-step. Also, find the tableau news at
    Tableau Online Course Blog.

    ReplyDelete
  3. A great content material as well as great layout. Your website deserves all of the positive feedback it’s been getting. I will be back soon for further quality contents. detective privado madrid

    ReplyDelete
  4. I really liked your blog post.Much thanks again. Awesome.
    Tableau Online Course
    Tableau Online Training

    ReplyDelete