How to calculate % in Pivot table

[Anonymous]

Hi All,

I want to calculate % of Total expression for the below scenariao.

For Breakfast-- expected o/p is 2/8,2/8,4/8  and for dinner----  75/102, 14/102,2/102 ,12/102  and for lunch  7/384,175/384......etc.

Can you help me to find logic for %Total.Please find the  attached qvw.

[aarkay29]

check this

[Anonymous]

Hi Kay,

If my TS Logic is   = count({<ShortText={'Nursing Unit Reporting Group'}>}DISTINCT (SurvID)).

what will be %TS ? Expected o/p is 261/9245,105/9245....etc

[aarkay29 · Accepted solution]

Did you try this:

count({<ShortText={'Nursing Unit Reporting Group'}>}DISTINCT (SurvID))/(count(Total<ShortText>{<ShortText={'Nursing Unit Reporting Group'}>}DISTINCT (SurvID)))

[Anonymous]

Thanks Kay,

it is working fine by replacing shorttext with Unit