Help for Best Approach to Pivot Table Used To Make Further Side Calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-1956707%22%20slang%3D%22en-US%22%3EHelp%20for%20Best%20Approach%20to%20Pivot%20Table%20Used%20To%20Make%20Further%20Side%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956707%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20an%20approach%20to%20displaying%20dat%20for%20further%20analysis.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20manipulating%20some%20raw%20data%2C%20I'll%20put%20the%20data%20in%20a%20pivot%2C%20which%20the%20end%20users%20use%20to%20display.%20Though%20some%20other%20pivots%20will%20be%20made%20for%20the%20purpose%20to%20then%20again%20analyze%20and%20forecast%2Fwhat-if%20analysis%20with.%20Sometimes%20the%20pivot%20will%20be%20displayed%20as%20a%20table-like%20view%20then%20add%20further%20calculations%20by%20the%20end%20users%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20trouble%20comes%20with%20the%20pivot%20not%20being%20dynamic%3B%20that%20is%2C%20if%20the%20end%20user%20needs%20to%20use%20the%20same%20pivot%20or%20there%20are%20new%20lines%20added%20to%20the%20pivot%20with%20a%20new%20filter%20all%20the%20calculations%20make%20no%20sense%2Fmay%20be%20overwritten%20by%20the%20pivot%20changing%20in%20size.%20I'm%20wondering%20what's%20a%20better%20approach.%20A%20data%20set%20with%20lookups%20to%20the%20work%20done%20in%20the%20raw%20data%20or%20via%20a%20pivot%20then%20putting%20that%20into%20a%20new%20sheet%20where%20all%20the%20needed%20data%20is%20available%20for%20whatever%20calculations%20that%20need%20to%20be%20made%20can%20be.%20I'm%20not%20sure%20how%20to%20approach%20crunching%20numbers%2C%20outputting%20that%20data%2C%20then%20to%20allow%20the%20end%20user%20freedom%20to%20add%20neccessary%20calculations%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20thought%20about%20getting%20the%20needed%20calculations%20from%20the%20end%20users%20and%20build%20those%20in%20so%20they%20don't%20need%20to%20do%20them%20or%20reduce%20the%20calculations%20they%20need%20to%20do%20manually%20so%20the%20workbook%20can%20be%20shared%20and%20make%20sense.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECalculated%20fields%20are%20okay%20but%20there's%20much%20to%20be%20desired%20with%20that%20and%20just%20looking%20for%20a%20way%20to%20make%20a%20clean%20and%20presentable%2C%20and%20more%20importantly%2C%20flexible%20with%20either%20a%20pivot%20view%20or%20some%20sort%20of%20table%20view%20that%20gives%20ability%20to%20customize%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1956707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I need help with an approach to displaying dat for further analysis. 

 

After manipulating some raw data, I'll put the data in a pivot, which the end users use to display. Though some other pivots will be made for the purpose to then again analyze and forecast/what-if analysis with. Sometimes the pivot will be displayed as a table-like view then add further calculations by the end users 

 

The trouble comes with the pivot not being dynamic; that is, if the end user needs to use the same pivot or there are new lines added to the pivot with a new filter all the calculations make no sense/may be overwritten by the pivot changing in size. I'm wondering what's a better approach. A data set with lookups to the work done in the raw data or via a pivot then putting that into a new sheet where all the needed data is available for whatever calculations that need to be made can be. I'm not sure how to approach crunching numbers, outputting that data, then to allow the end user freedom to add neccessary calculations

 

I've thought about getting the needed calculations from the end users and build those in so they don't need to do them or reduce the calculations they need to do manually so the workbook can be shared and make sense. 

 

Calculated fields are okay but there's much to be desired with that and just looking for a way to make a clean and presentable, and more importantly, flexible with either a pivot view or some sort of table view that gives ability to customize the data.

0 Replies