Forum Discussion
Solved
Percentages in Pivot Table
Hi, Here is a sample pivot table in which I am trying to determine the percentage of notes doctors are blocking. How do I get the third column (H) to show the percentage of blocked notes? Obvious...
I'm not sure if you're looking to do G/F or G/Total so I've included both options using GROUPBY.
for G/F:
=GROUPBY( SampleTbl[Doctor], SampleTbl[Shared with Patient], HSTACK(COUNT, SUM, LAMBDA(v, SUM(v) / COUNT(v))) )for G/Total:
=GROUPBY( SampleTbl[Doctor], SampleTbl[Shared with Patient], HSTACK(COUNT, SUM, PERCENTOF) )
The first solution you gave was the appropriate one. I appreciate is SO MUCH! And now I have a new function to explore :).