How to add sales measure AND % of sales measure to Matrix

[Anonymous]

Hi,

I want to show rows that are product sales AND I also want to show what each row's product sales % of total are in a Matrix. I can figure out how to add sales or change the sales to show as % of grand total but I can't figure out how to have both measures in my matrix?

[Greg_Deckler]

Just add it twice. Format one as % of and leave the other one alone.

[Anonymous]

@Greg_Deckler 

I can't figure out how to add it twice. It won't seem to let me drag it into the visual or onto the Values shelf.

[Greg_Deckler]

That's strange, what visual are you using?

[Greg_Deckler]

Nevermind, you said Matrix. I realize this video is for a Table visual but works the same for matrix.

[Anonymous]

@Greg_Deckler 

I don't see a link for a video so I can watch as well?

[Greg_Deckler · Accepted solution]

@Anonymous Yeah the first attempt failed miserably so I posted it out on YouTube and then it seemed to work. Check the post directly above your last reply.

[Anonymous]

@Greg_Deckler 

Thank you...that was what I was doing earlier and for some reason it worked. It least you proved to me that it does work and I'm all good on my end now.

Thanks

[Greg_Deckler]

Cool, glad it worked! That's really frustrating when something you know should work doesn't!! Maddening!

[Greg_Deckler]

Alright, that failed miserably, try this one: