Pivot table subset showing percentage of complete dataset

[Bjernald]

I'm currently working with a dataset which has one dimension(column) with categories a,b,c,d,e, and one dimension(column) with categories 1,2,3,4. I've exported subset 4 and made manual categorization of it, let's call them !,?,#,@. Then i made a pivot table of the subset with categories a,b,c,d,e as rows and !,?,#,@ as columns. I want to show the row total in my pivot table as percentage of the row total of the complete dataset. For example all the a:s in subset 4 as percentage of a:s in complete dataset.


Any suggestions? I've tried building different relational models but no luck so far


Thanks