I want feedack percentage if pending than 0% if accepted than 100% if 1 pending 1 accept than 50%

[aayushmanmishra]

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

[#2 · Accepted solution]

@aayushmanmishra 

The 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)
  )

[#3]

great thanks