1 Reply Latest reply on Nov 15, 2016 2:49 PM by Shinichiro Murakami

    Display a measure as a subtotaled attribute on a dimension?

    Michael Damico

      I may not be asking the question perfectly, but what I want to accomplish is this: We have some dimensions (Department, Code) that we're grouping various measures on. We also want to show Revenue in this viz, but revenue cannot be obtained at the Code level, only at the Department level. However, we'd rather not repeatedly show the sum of the measure as that doesn't make sense in the viz at the Code level, but it does at the Department level (see screenshot below).

       

      2016-11-15_16-24-22.png

       

      How could I accomplish this? Ideally I'd have some type of subtotal of department on the rest of the measures, and the Revenue attribute would then show correctly, and THEN it would make sense for comparison.

       

      Thanks,

      MD