5 Replies Latest reply on Jun 16, 2017 7:49 AM by Girdhari Sharma

    Default count for group if no count

    Girdhari Sharma

      Hi,

      I am using excel file that contains Tower, Team, Status, I have 4 status R, G, A, T on the data.

      below is source data

       

       

       

      TowerTeamStatus
      Tower1team1G
      Tower2team1G
      Tower3team1G
      Tower4team1A
      Tower5team1G
      Tower6team1G
      Tower7team1T
      Tower8team1G
      Tower9team1G
      Tower2team2R
      Tower3team2G
      Tower4team2R
      Tower5team2A
      Tower6team2G
      Tower7team2R
      Tower8team2A
      Tower9team2G
      Tower10team2T

       

      Tower has multiple teams, i want to have the count based on 4 status on team level. Some of the teams do not have one of the 4 status. I want the default value as 0(zero) if no value. currently it has 3 groups and deos not show 4 value.

       

      following is the data

       

      actually it should be Team wise

       

       

      request you to update me on the same

       

      let me know if you need any other information.

       

      soruce table

       

       

      Thanks & Regards

      Girdhari Sharma