3 Replies Latest reply on Feb 7, 2018 7:41 AM by Joe Oppelt

    Add a Calculated Field as a Value in a Hierarchy

    Paul Lim

      Let's say my worksheet is reading off a dataset where there is a hierarchy between Account Group & Account Type. The dataset looks like this for example:

      Image 1.PNG


      The worksheet would look like so:

      Image 3.PNG


      Now without having to change the underlying dataset, is it possible to add a Gross Margin calculated field that accommodates the hierarchy between Account Group & Account Type? The Gross Margin in this case would be [Revenue] - [Labor] - [Supplies]. Ideally, the Tableau worksheet would look something like below:

      Image 4.PNG