Macro to Split pivot table

[excelworks]

Hi all
i am trying to create a macro to record the splitting of picot table ie every time i create pivot table for two of my parameters i want macro to be able to go to each row in pivot table and "double click or show details" and save it with a name EXCEPT FOR LAST ROW in pivot because it gives me grand total which i don need
am stuck in this for long time please help