2 Replies Latest reply on Jul 8, 2018 9:40 AM by Swapna Chennam

    I need to divide quarter totals of one hierarchical level with the quarter totals of other level which is my lowest level

    Swapna Chennam

      Tableau gurus,

       

      2-1-1 is my lowest level and all the others are higher levels. My requirements state - take the actual of 2-1-1 as numerator and selected level (2-2-2 or 2-3-2 etc) as denominator. I cannot get this to work whatever. If you look at the attached workbook, I need to divide 452532 "Sheet 102"  with 16815 on "By Quarter-Weighted APE" so on and so forth for each quarter. Tried fixed, exclude etc etc, couldn't make it to work. Any ideas?