Thanks all of you for your help and reply. I still need to go through these document to understand it better. Now I am thinking if PowerPivot is better then why I do not escape pivot table and start learn power pivot since I have feeling that powerpivot can do what pivot table can do and much more. thanks a lot.