11 Replies Latest reply on May 25, 2016 10:55 AM by Mahfooj Khan

    Aggregating percentage on higher dimension

    Mayank Gupta

      Hi,

       

      I'm new to Tableau. Here is my problem statement:

       

      I have nested categories: Portfolio->Area->Function->Project id. I've created one calculated field to calculate some percentage on most granular level (Project id). But when I replace Project id with Function it simply adds the percentage values. For example - there are 2 Project ids showing 60% and 70% but on Function level its showing 130% which is wrong. So I want to know if there is a way to dynamically calculate percentage based on the hierarchy of dimensions?

       

      Hope i'm able to explain my problem precisely.

       

      Thanks,

      Mayank