On a Financial report we have "extra" metrics that need to be calculated within the pivot table. Currently my Sisense Pivot table does NOT include the GROSS PROFIT, EBITDA, EBITDA % and Net Income %. Those are the "extra" calculated metrics that are needed for this to be a truly valuable report. In addition to the extra calculations listed below, the report needs to be YTD, then the most current Closed Month, then the previous month until the beginning of the year. This will allow finance to see what exactly has happened through out the year.
Gross Profit = Revenue + COGS <Cost of Goods Sold aka Cost of Sales> .
EBITDA = Gross Profit + Expenses
EBITDA % = EBITDA / Revenue
Net Income % = Net Income / Revenue
The highlighted Yellow in the screenshot are the added value calculations:
I need a way to add these added values to the pivot tables.
Please sign in to leave a comment.