Problem regarding Pivot Table

[sarfaraz_sheikh]

Dear ALL ,

I want to design the Pivot table like below...

and i have made till here like below

I am not understanding how to design for FTNR % like above exel snapshot...can anybody please help me how to design the same as exel....below my file is attached for your reference and logic is as follows :

FTNR  = count(DISTINCT {$<DISP_CATEGORY={'*'}>} SI_NO)

Inward  = COUNT(DISTINCT SI_NO)

Regards

Sarfaraz

[arulsettu]

if you share the real excel it would be easy to do

[sarfaraz_sheikh]

Dear arun,

real exel is to large..my concern is to achive pivoting same as exel snapshot ...thats it .

Sarfaraz