Hello... I need your help. I've tried to solve but I could not.
I need to show a measure (% Respect Revenue) in some rows into a Pivot table (Operating Expense and EBITDA)... until this part I could do it as I show you in the first image (Operating Profit (before D&A) showing a measure in blank).
When I open the content of Non-Personel show the items into it, and each one show the % Respect Revenue (Red rectangles). But We need in this point that only show blank and the % Respect Revenue appear only into the subtotal (Green rectangle) as I show you in the second image. Is this possible?.
Finally, I've attached an image with the measure in order to give you a best idea of our data.
I think the problem you have is derived from the way you calculated [All Revenue] measure I believe it's a sum of all revenues (non-personnel + personnel...etc) so if you calculate your Non-Personnel in separate measure then it will be blank, try something like this maybe it will work for you: