7 Replies Latest reply on Jun 6, 2016 7:32 PM by Nutan Patel

    Need help in grouping

    Nutan Patel

      Hello Experts,

       

      Bassem Khalil

      I was playing with tableau and I stuck in between.  I want custom grouping based on my Bank column. Refer below image as a reference.

      image.JPG

      In the above image, left side is my raw data and right is side is the output I expected. When we put bank in the row shelf and drag deal value & number of records measure, It aggregate the measures based on bank value. That's the correct behavior. The challenging part for me is to look into the bank column and consider rows in the aggregation if the value contains the individual name.

      For example, for HDFC bank report should aggregate the data for 2,3,5,6 & 9 rows. 

       

      Is this feasible in Tableau ? If yes, then please share your thoughts.

       

       

      Thanks

      NP