May 05 2022 03:04 AM - edited May 05 2022 03:05 AM
Advisor Name | Accept | Pending | Grand Total | Percentage |
A | 1 | 1 | ? | |
B | 1 | 1 | ? | |
C | 1 | 1 | ? | |
d | 1 | 1 | ? | |
e | 1 | 1 | ? | |
f | 1 | 1 | ? | |
g | 1 | 1 | ? | |
h | 1 | 1 | ? | |
i | 1 | 1 | ? | |
j | 2 | 2 | ? | |
k | 2 | 2 | ? | |
l | 1 | 1 | ? | |
m | 1 | 1 | ? | |
Grand Total | 7 | 8 | 15 | average |
secondly this data is in pivot form than how to get this percentage value using pivot options only. instead of using formula
May 05 2022 03:44 AM
SolutionThe first calculation you describe would appear to be
= Pending / (Accept+Pending)
The conversion to pivot table normalised form is a major task by comparison, Using 365 beta
= LET(
a, HSTACK(Advisor, Accept, IF(Accept,acceptHdr)),
p, HSTACK(Advisor, Pending, IF(Pending,pendingHdr)),
combined, VSTACK(FILTER(a,Accept>0),FILTER(p,Pending)),
SORT(combined)
)
May 05 2022 04:00 AM
May 05 2022 03:44 AM
SolutionThe first calculation you describe would appear to be
= Pending / (Accept+Pending)
The conversion to pivot table normalised form is a major task by comparison, Using 365 beta
= LET(
a, HSTACK(Advisor, Accept, IF(Accept,acceptHdr)),
p, HSTACK(Advisor, Pending, IF(Pending,pendingHdr)),
combined, VSTACK(FILTER(a,Accept>0),FILTER(p,Pending)),
SORT(combined)
)