9 Replies Latest reply on Sep 4, 2018 1:33 PM by Joe Oppelt

    Adding a Subcategory to each other

    Eugene Trilesnik

      Hey guys, I have attached an excel document with some test data. I know how to make calculated fields but im wondering if I can do calculation on subcategories. For example In the actual column I want to take the With Actual and divide by the Net Actual amount. Aka I have different accoutns but same column. Is that possible in tableau? All Im getting right now is just finding a difference in 2 columns and not in 1 column different accounts


      Numerical example would be Account Net, Campus 1, Actual = 250.8, Account With, Campus 1, Actual = 4. I want 4/250.8 * 100


      Thank you!