All,
I have a Power Pivot Data Model built to calculate aspects of a P&L by product and customer. There is a working Excel file where exporting the data in a table format as a values only table could be dropped into this file to run additional calculations. Is there a way to materialize a table that is built using measures? I tried to create a tabular pivot table to model it, but the pivot table started hogging too much memory, and it doesn't help that everytime I drop something in, I keep getting the subtotals added back despite the fact I have turned them off.
For the record I would prefer to just work in Power Pivot, but for others to use it must just work within Excel, hard to get people to download let alone update the add-in at my office. In addition, Power Pivot still continues to have a lot of frustrating crashes which others will complain about.
Thanks.
I have a Power Pivot Data Model built to calculate aspects of a P&L by product and customer. There is a working Excel file where exporting the data in a table format as a values only table could be dropped into this file to run additional calculations. Is there a way to materialize a table that is built using measures? I tried to create a tabular pivot table to model it, but the pivot table started hogging too much memory, and it doesn't help that everytime I drop something in, I keep getting the subtotals added back despite the fact I have turned them off.
For the record I would prefer to just work in Power Pivot, but for others to use it must just work within Excel, hard to get people to download let alone update the add-in at my office. In addition, Power Pivot still continues to have a lot of frustrating crashes which others will complain about.
Thanks.