7 Replies Latest reply on May 7, 2015 1:06 PM by Sarma MVJ

    Aggregates based on Partitions

    Sarma MVJ

      The sample denormalized data is follows

       

      Teacher  ID

      Program Id

      Participant Count

      1

      1

      23

      2

      1

      23

      3

      1

      23

      4

      2

      32

      5

      2

      32

       

      For example, there are 23 participants in program 1, which is taught by 3 teachers.

      I am trying to get the following aggregated result in tableau.

       

      Teacher Count

      5

      Program Count

      2

      Participant Count

      55

       

      Any help is much appreciated.