Hello. I am trying to biuld a P&L report using PowerPivot. How can I show Gross Profit, Operating Profit and Net Profit, and enable drill down into hierarchy?
Up to now I am able to show these subtotals correctly, but cannot make it work on an hierarchy.
David Churchward wrote several very thorough posts about P&L's in PowerPivot. Check out the links here for more info and worked examples.
Brent Greenwood, MS, MCITP, CBIP
// Please mark correct answers and helpful posts //
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?