Hi:
I know how to create a Power BI report that pulls amounts for dimensions based on the account categories of Revenue and Cost of Goods Sold.
But, I cannot get the report to mirror what is shown in the screenshot below.
The tables that I'm using are GL Entries, Dimension Set Entries, and Chart of Accounts.
It seems that there is not an obvious way to have two separate columns for Revenue and COGS.
Has anyone out there found a way?
Thanks!
John
