This can be acchived from display-->sattement of account-->statistic Select Sales and export SET Export For Pivot tablte to YES