4 Replies Latest reply on Jan 20, 2015 8:53 AM by Iain Henderson

    How do I implement a Formula field that counts where cells 'are not blank' and summarises in a row?

    Iain Henderson

      Hi there, i'm a relatively new user to Tableau. I get the basics but am struggling with formulas/ calculated fields. I'm looking to build a formula that adds up the number of products where a sales figure > 0, the sheet has products along the top with a summary, and customers down the side with a total.

       

      I know this can be done easily enough in Excel, but don't want to have to export to get there.

       

      Any suggestions?

       

      Thanks

       

      Iain