data not matching in Pivot table

Dear Cool Friend,
Using other words to what MallyCat said, Row Labels will not do any calculation for you. If you want your total to tally then it has to be under values.
Now coming to your problem did you try placing the other headers in Row Label or report filter keeping sum of marks in value field. This should address your problem. If not, then please upload a sample data sheet with all the columns and few sample rows of data.
Best Regards/VKS

Hello VKS,

i have attached the master(adc) and it carries the file too which i am getting using pivot table. i have considered four rows in it only. Now please help me in getting the data correctly using pivot or some other function.


Thanks alot
Shane