Hi,
I have a pivot table with about 12 columns and 50,000 rows in a tab. I want to created a weighted sum across a few different items for a given institution in a given year (e.g. Item A*2 + item B + Item C in 2000 for institution A and again for institution A in 2001, and so on for Institution A and all others in all years). I use a calculated item in my pivot table and it works okay, except that it slows my computer down to a crawl. I have found that my computer runs quicker if I create new data in the source data tab and use this, rather than creating a calculated item. It adds extra rows to the source data, but seems to be the better option.
My question is: Is there a way to create a calculated item and have this data exported directly to the source data tab?
At the moment I am copying the data to another spreadsheet, making the calculations, and then inserting the appropriate descriptions in the columns (e.g. institution, year, description of the calculated item).
Thanks,
Peter
I have a pivot table with about 12 columns and 50,000 rows in a tab. I want to created a weighted sum across a few different items for a given institution in a given year (e.g. Item A*2 + item B + Item C in 2000 for institution A and again for institution A in 2001, and so on for Institution A and all others in all years). I use a calculated item in my pivot table and it works okay, except that it slows my computer down to a crawl. I have found that my computer runs quicker if I create new data in the source data tab and use this, rather than creating a calculated item. It adds extra rows to the source data, but seems to be the better option.
My question is: Is there a way to create a calculated item and have this data exported directly to the source data tab?
At the moment I am copying the data to another spreadsheet, making the calculations, and then inserting the appropriate descriptions in the columns (e.g. institution, year, description of the calculated item).
Thanks,
Peter
