horizontal percentage in pivot table

[brijesh1991]

Hi,

As per the attachment, I wanted to have horizontal %.

Example: for only Row A:  >1%=  >1/(>1+>2+>3)

In our case >1%= 5/(5+4+6)=5/15=1/3=33.33%

If I do: Sum(value)/ Sum(Total Value)--- then it's giving me vertical total as denominator of % formula.

Can you please help me with set analysis,

[Kushal_Chawda]

Please share the sample application

[brijesh1991]

Please find the demo app.