Jun 28 2021 10:39 AM
I'm doing a simple P&L. I can't get my group totals to show. Specifically "Gross Profit" or "Net Operating Income". I've built this model before in BI, but it isn't working in Power Pivot. I've dumbed down the model to 3 simple tables with just a few rows to try to get it to work.. I have a Chart of Accounts, A Report Heading and an Amounts table. If I only show Headers - Income/COGS/GP, etc...subtotals and formulas work fine. But, I I add Account names - my subtotals go away.
I've got a sumamt calc, a subtotal calc and then a "switch" as to which to show.
Help, please!
Jun 28 2021 02:07 PM
Jun 28 2021 06:35 PM
@Sergei Baklan Yes. I can't get Gross Profit, Operating Income, Net Income to show, when I add the "Name" (sub category) column. I'm also not seeing the totals for Income and Expense, but the category labels are there at least.
Jun 29 2021 03:14 PM
Jun 29 2021 04:25 PM
Jun 29 2021 04:28 PM