Thank you for reply
using these option the comand return the all data in %
but i required a saprate column after grand total contain share in grand total for each row like if first row total is 20 and the grand total is 40 so it is 50% of grand total and i wand this result in seprate column who i required.
At the 'layout' stage of the pivot table set up wizard, you've laready managed to drop the column heading for whatever you are totalling into the data area. just do it twice, then apply the changes as above.
I apply this settings but here a problem is that i maintain this report yearly so in this report i have seprtate column for every month and when i apply these settings it return a column after every column but i required a single column after grand total no need a column with every column in data area.