2 Replies Latest reply on Oct 3, 2016 2:02 AM by Pallavi P

    Calculated field to obtain the total/ sum of a specific category within a Dimension

    Edwin Lam

      Hi,

       

      I am quite new to Tableau and therefore I am wondering if there is a way to perform a calculation to determine the sum of a specific category within a Dimension.

       

      For instance with data below, I hoping to calculate the sum of total loan balance of accounts with LVR 80+ as part of a calculated field, essentially I would like to calculate for each postcode, the % of the total balance in that specific postcode that has a LVR of "80+"%.

       

      What is the best way of approach to this problem?

       

       

      AccountLVRPostcodeloan Balance
      91280+3000$10
      23480+3000$20
      13621-603141$50
      32261-803142$14
      3120-203480$12

       

      Thanks!

       

      Edwin