9 Replies Latest reply on Jan 21, 2014 1:18 PM by Nicholas Abbott

    Simple Calculation of working out a % with Grand Totals and a free fill number

    Nicholas Abbott

      Hi everyone,

       

      Being fairly new to Tableau, I'm wondering if you can help me and if you have had the same queries...

       

      I have a table (attached is a screenshot) showing you the grand total of certain information. I am wanting to divide the grand total by the total number of apartments which is a fixed number - say its 519, however, I do not know how Tableau calculations would do this.

       

      Eg. Grand Total: 177 / 519(free fill number) * 100

       

      Thanks for your help!