Is there a way to generate a summarized table in within Power Pivot and then have some calculated columns based on the summarized date?
In the example below, consider I have 2 tables, one with financial data and another with Sales data. Each Master Account may have 0 or more rows of data in each table.
I need another table that lists all the Master Accounts from both tables and provides the summarized revenue and deal value for each. Post that I want to create some calculated columns based on the summarized data and use those columns as slicers in the dashboard.
How can I do that?
In the example below, consider I have 2 tables, one with financial data and another with Sales data. Each Master Account may have 0 or more rows of data in each table.
I need another table that lists all the Master Accounts from both tables and provides the summarized revenue and deal value for each. Post that I want to create some calculated columns based on the summarized data and use those columns as slicers in the dashboard.

How can I do that?