10 Replies Latest reply on Sep 20, 2013 3:20 PM by Tracy Rodgers

    Question on Aggregation

    Sameer Mittal

      Hi All,

       

      I'm running into an issue with the aggregation. I hope somebody might be able to help me.

       

      Product GroupCategoryItemOrder Quantity
      1a12312
      b4564
      7862
      2a9451
      b4564
      5781

       

      Say when running the Pivot on this, If I get rid of the Product Group Category I want the result to be shown as

       

      CategoryItemQuantity
      a12312
      9451
      b4564
      7862
      5782

       

      See how it is not doubling up the quantity for Item 456, technically the text table would aggregate it and show the quantity as 8. I hope if somebody could help me a way to get only the unique data. Because technically Item 456 just happens to fall under both product group 1 & 2 and the quantity sold were only 4.

       

      Thanks.

      Sameer

       

      Message was edited by: Sameer Mittal If you look at sheet 2 the Item 456 is showing as 8 in the quantity where in actual only 4 were sold. Is there a way that I could get tableau to avoid aggregating it multiple time. I understand why it is doing so, I just wanted to understand if there is a way to get around that. Thanks. Sameer