3 Replies Latest reply on Mar 5, 2017 5:50 PM by Nguyen Yen

    How to group data from Sub-category but excepting Category?

    Nguyen Yen

      Hi All,

       

      I'm Yen, I have a data about Category and Sales as below.

      3-2-2017 3-46-38 PM.png

      I want to group some sub-categories into one group by Category, example: Orange, Apple, Mango and Peach into Group "Fruit", Egg, Chicken and Fish into Group Food.

      But when I conduct this in Tableau, the data is wrong. This means when I only drag Category and Sales to visualize, Sales will be doubled, include sales of Food that I colored.

      3-2-2017 3-53-39 PM.png

      Any ideas how to insolve this issue in Tableau?

      Please help me regarding.

       

      Thank all.