5 Replies Latest reply on Oct 6, 2017 1:40 PM by Shawn Wallwork

    Excluding categories with max counts in tableau

    barathkumar vijayakumar

      Hi,

       

      I have data by client and & state (See below), now I need to exclude the states with max count and calculate the total.

      in this example for Client A I need to exclude Florida from total counts (5433) because it has max 5408 counts, so the remaining total will be (5433-5408)= 25.

      but this will change for client B because client B will have max counts in state Georgia

      Can someone please help me with this ? is it possible to