Hi Sam ,
I Created Matrix table that has Category In the first level and Under each category, there are an Items.
I have a measure that calculates the Views of each Item, based On this I have the grand total for All categories
and subtotal for each category (No Problem here). I need to calculate the percentage of Views for each Item based on the (Grand Total) and to the Subtotal for each category, The problem is when I set the measure (percent of grand total) it works fine (No Problem here), But when I set the measure to (percent of column total) it brings the percentage as it (percent of grand total) which is totally wrong.
Please Take a look at the screenshot with this message to understand the Written text above to understand the Case.