1 Reply Latest reply on Feb 9, 2017 8:55 AM by Patrick A Van Der Hyde

    Customize subtotals

    Frederic Huet

      Hi,

       

      Can anyone please help me how to achieve the following subtotal format in Tableau:

       

      CountryClient NameDescriptionJan-2017
      United StatesAgency ANo of clients10
      Revenue per client (USD)15
      Turnover (USD)150
      Agency BNo of clients30
      Revenue per client (USD)20
      Turnover (USD)600
      TOTAL UNITED STATESNo of clients40 (30+10)
      Revenue per client (USD)18.75 (750/40)
      Turnover (USD)750 (600+150)

       

      Thanks for helping

       

      Best regards,

       

      Frederic