I have been experimenting with and researching/learning about power pivot tables, but I haven't found the solution to my requirement so I am hoping someone can help.

I am using the default sales power pivot example file. I am trying to add a row that gives the order total as well as the sum of the profit and margin % per order. Or maybe adding them as new columns that only display in one cell per order.

Power pivot (and pivot tables in general) are fairly new to me. If anyone has online resources for in-depth learning I would be grateful for links.

Thanks!

Matt