Table Matrix Just Show Percentage of Grant Total Column

[mpichardo]

Hello,

I have a matrix table filled with values in normal number format.

I also have a totals column.

I am just looking to add a percentages of the totals next to the totals column. I do not want to see percentages for each column that exists. Just the totals column.

How can I add this one column addition onto my matrix table? 

[mpichardo]

Yes just like that, by the way, your code where did you write that? Into Calculated Column? I am trying to duplicate your formula for my table

[vega]

You need to create a measure

[mpichardo]

Are you sure its a measure? Everytime I put in the semicolon I get an error I tried calculated column that didn't work either.

[vega]

That is probably because the responder is from another country. I believe in Europe they use semicolons. Try to replace the semicolons with commas.

[waltheed]

Yes @vega is right. It is a measure. and you may need to replace the ; with ,   Sorry about that. 

[waltheed · Accepted solution]

Hi mpichardo, 

Do you mean someting like this?

I could not find an "official" way to hide the % column for each year. What is did is just make the column smaller. 

Also I changed the formula, to exclude values for the year level. 

% of total =
IF (
    ISFILTERED ( 'Date'[CalendarYear] );
    BLANK ();
    DIVIDE (
        [Sum of SalesAmount];
        CALCULATE ( [Sum of SalesAmount]; ALL ( FactOnlineSales ) )
    )
)

Hope this helps. 

[Anonymous]

How did you exclude the Value header and column subtotals for "% of total"?

[waltheed]

I could not find an "official" way to hide the % column for each year. What is did is just make the column so small that you don't see it.  

[Anonymous]

Oops, I forgot I had word-wrap on.  Thanks for the quick response though!