Stacked Column Percentage Calculation Groupings (X-post)

[trankillity]

Hi all,
I made a post over in the normal Excel forum on here, but I didn't get any replies as I have a feeling it's more relevant to this forum.

Here's the link to the original post. Basically I'm trying to find out if there's ways to change the "Show values as" to show different values based on different levels in the pivot hierarchy. Examples and full explanation in the original post. Hopefully someone here can help out.

Thanks in advance!

 

[scottsen]

I suspect this is what you need:
Clever Hierarchy Handling in DAX – SQLBI

 

[trankillity]

Should definitely do the trick. Thanks Scott!