1 . u can use partial sum in pivot table to display totals & grand totals
2 . yes In pivot table properties there will be a sort tab where u can sort your products by using a expression
3 . It allows but u have to modify your sort expression & may be it will mess your chart by using dual sort s
4 . yes u can add rank to each product based on amt by using rank expression ...
Thanks a lot