Hi, I have a hierarchy HL1 HL21 HL211 HL212 HL22 HL221 Users access this cube data in Excel. They place this hierarchy in the COLUMNS section of pivot. The result should be as below in the image. ![72489-capture.png] : /answers/storage/attachments/72489-capture.png Basically when the user selects HL21 in the hierarchy and is at that level, it should show the balance for HL21 i.e. 600$ However when the the user drills down to the next level -> excel displays HL211, HL212, HL213 -> the new measure should still show the balance of HL21 -> $600 Please help.