4 Replies Latest reply on Mar 6, 2014 10:45 PM by Prashant Sharma

    Select certain values from a dimension

    Michael Lynton

      I am brand new to Tableau. I've dabbled a little bit with calculated fields, and I am thinking a calculated field might accomplish what I need.

       

      I have a list of accounting GL codes, ie 4000, 4001, 4002, 4003, 4004, etc.

       

      What I want to do is have a new dimension that only includes 3 of those codes - ie 4000, 4001, and 4002. These particular codes make up "net income" for accounting, and I'm thinking this would be easier than filtering the codes every time.

       

      Anyway, is there a syntax/recommended way for creating a new list of values like this? I'm open to all and any feedback also. Thanks. @