Pivot table option

[vinayjan]

Hi,

I have data of attendance. In the first tab of Consolidated report pivot table is showing average of Scheduled Leave % Unscheduled Leave % Overall Absenteeism %. In actual data which is next i don't find this column. Also in pivot table field list there are 5 option of Sl%,UL%,Scheduled Leave % Unscheduled Leave % Overall Absenteeism %. I'm not finding from where this data is gathering and how. There are no hidden cells or data of this. But still this data is coming in pivot table.

Could anyone of please explain me how to create this explain the steps also the formula if its there. Coz even i want to create the same kind of reports in new workbook.

Thanks in advance!!LMS Coventry_Updated 08202013.xlsx

[amy_d2]

Hi

just double click on Scheduled Leave % in pivot report you will get a pop up window , where you will find source name as "SL" 9which is from your data column & Custom name as "Scheduled Leave %" (which is manually written by user of this file)

i hope this is what you want to understand

[vinayjan]

Thank you.But i didn't understand from where this source SL% is coming from. There is no such column in the data. Than also this data is calculating Percentage of SL.

what is the way to get this information.

[amy_d2]

Hi

you can check cell AU 2 in "scheduler" tab that is SL or schedule leave, pivot is just taking the percentage of total SL in the month of march 13

[vinayjan]

Could you please tel me how its taking this percentage. I have not inserted any column name called SL% or UL% or overall %. How its possible to track this information without adding column

[vinayjan]

Could you please tel me how its taking this percentage. I have not inserted any column name called SL% or UL% or overall %. How its possible to track this information without adding column.

I have created Lead wise tab now and even i want that SL%,UL% etc cells should be in pivot. But its not tracking.Copy of LMS Coventry_Updated 08202013.xlsx

[amy_d2]

Could you please tel me how its taking this percentage. I have not inserted any column name called SL% or UL% or overall %. How its possible to track this information without adding column

true as i am also checking the same

[vinayjan]

Hi Amy,

i got it. After lots of head storming finally i came to know this. In Pivot table we have a Option tab. Here we can Insert calculation fields. The same is added in attached file too.

Thanks for your help!!!