sub total in chart with out demenions

[kylealpaugh]

I have a chart with 5 dimensions and 4 expressions. 

I want to be able to only show one of the dimensions in the straight table the only problem is when i don't have all the dimensions in the chart it the sub total and numbers are off. I was able to hide some of the dimensions by going to presentation and clicking on hide but it still shows values i just want to see the sub total number is that possible ?

The top chart is with all the dimensions and the bottom chart is what i was able to get it down to. I want to show only the dimension company and only the sub total of it.

[bharathadde]

Try below in the expressions, i'm assuming field name of Company is 'Company' and Expression fields names are header names.

Price Mvmt

Sum(Total <Company>[Price Mvmt])

2018 Sales YTD

Sum(Total <Company>[2018 Sales YTD])

2019 Sales YTD

Sum(Total <Company>[2019 Sales YTD])

%Growth

=(Sum(Total <Company>[2019 Sales YTD])-Sum(Total <Company>[2018 Sales YTD]))/Sum(Total <Company>[2018 Sales YTD])

Hope it helps you