Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
pls reply ...if know the resolution ....its urgent
sarfaraz
check the attached file of yours because it dose not have that much SUB_VERTICAL_DESC
Hi arul,
Thanks for your reply !!!!
The Sub_vertical_desc which attched exel sheet have is sample data ......i just want know how i can design the pivot table as per my expectation .....I tried that but failed to do so ....is there any way to achieve the same
Regards
Sarfaraz
I guess you have sent some other file...chan you please check and update it
Hi saumya,
the attched exel file is sample data .....i just want to design as per my expectation ....please suggest me a way to achieve the same ....
Regards
Sarfaraz
i assume to find FNTR % try like this
add another expression like this
count(DISTINCT {$<DISP_CATEGORY={'*'}>} SI_NO)/COUNT(DISTINCT SI_NO)
go to number tab and enable show in percentage
Dear Arul,
I know how to calculate for percentage ...my requirement is how i can get the design like exel snapshot in pivot table..
Sarfaraz
design means creating all the columns?
Design means how i can pivoting like above same as my exel snapshot.....i want entire sanapshot to be developed in pivot table ..
Sarfaraz