PowerPivot is awesome and I've been trying to provide income statement presentations using this tool. I need the following calculations within the pivottable:
- comparative period variances ($'s and %'s)
- gross margin % calculation on a row, displayed for each column (calculation would be row 2-gross profit, divided into row 1-sales)
- solution needs to accommodate ability to drill down further (ie company summary to division, branch or account level)

The data tables are fairly complex and I've exhausted my tricks in getting what I want to this point. I was actually trying to find a PowerPivot Pivot Table black-belt that could offer consulting/training for a few hours. Thanks!