1 Reply Latest reply on Sep 1, 2016 5:36 AM by Ryan Eavey

    Another grand total / sub-total question

    Eric Sturgeon

      I'm stumped trying to do something that I think should be easy ...  In the example below, instead of showing an overall grand total, I want to see the totals of each category, furniture, office supplies and technology, in all states, like I've posted below the Tableau screen shot.  The only way I've figured out how to do this is to duplicate the worksheet and remove state as a row, but I want to see everything in one worksheet because I'm exporting the table into Excel.  I've read through the "Why my Totals aren't Working" post and the Working with Numbers tutorials but to be honest, a lot of that stuff was over my head and I think (I hope) that what I'm trying to do is much simpler.