Pivot table shaow parentage as grand subtotal

[Haitham Darweesh]

helllo

 I need to show values  as a percentage but not as grant total, it must be as grant subtotal as shown in the image  

[#2]

Hi,

I guess that's show as % of Parent Row Total in value field settings

[#3]

thanks Sergei Baklan

Unfortunately, % of Parent Row Total it gets the value and divided by the total number in the same column. like in my example: 36 / 50

[#4 · Accepted solution]

Hi Haitham,

I see, sorry for misunderstanding.

If creating pivot table you added your data to data model (usually default option) I'd add couple of measure (in PivotTable fields window right click on table name) like

PercentYes:=CALCULATE(SUM(MyTable[value]),MyTable[answers]="yes")/CALCULATE(SUM(MyTable[value]),ALL(MyTable[subcategory],MyTable[answers]))

similar for "no", and show them instead of number of yes and no. Not to forget to apply % format to the measure on creating.

Not sure about your field names.

[#5]

thanks so much Mr. Sergei Baklan