1 Reply Latest reply on Jun 27, 2016 4:35 PM by Patrick A Van Der Hyde

    Faking in an aggregate measure

    nick.cook.0

      I have a raw dataset of a very select portion of the population to do analysis on. But I want to bring in the balance of the population as a line item to calculate % of Totals.

       

      For example, my dataset is based on users that have performed a task and the balance of the population (what's not in my dataset) are the users that have not performed a task. I would like to be able to show the results like such:

       

      Task PerformedCountPercent
      01,200,00099.1%
      110,1000.8%
      2+8000.1%

       

      The blue rows represent the dataset I have. The white row is the balance total I want to bring in for comparison.