Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Matrix - show percentage only on total Column

Hello,

 

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

 

I am just looking to add a percentage 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 to my matrix table? And not have the % on each column under the Year/Week

Thanks! 

Need Help
Show and Tell
Tips and Tricks

8 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous ,

    Have you tried to format that measure as a percentage?

     

    When you have your measure in the edit window, go to the modeling tab.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Nathaniel_C 

      Thanks for the quick response and trying to help. 


      What I'm looking for is to not have the Percentage on each column but only in the Grand Total. Right now I do have the percentage but across every column, which I don't need. 

       

      Makes sense?

       

      Best, 

      • Nathaniel_C's avatar
        Nathaniel_C
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Anonymous ,

        What about two measures that are the same. Percentage weekly, Percentage Total, formatted differently, or am I misunderstanding the issue?

         

        If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
        Nathaniel