fluctuation value in a column of a Table in Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2029464%22%20slang%3D%22en-US%22%3Efluctuation%20value%20in%20a%20column%20of%20a%20Table%20in%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029464%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20Table%20that%20contains%20Product%2C%20Purchase%20date%2C%20Quantity%20Purchased%2C%20Purchase%20price%20%26amp%3B%20Market%20Price.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20Pivot%20Table%20for%20this%20Table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20market%20Price%20gets%20displayed%20on%20Pivot%20table%20either%20a%20sum%20or%20Average.%20My%20requirement%20is%20to%20have%20original%20uncalculated%20Market%20price.%20i%20do%20not%20see%20any%20option%20in%20Pivot%20table%20field%20settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindly%20help%20me%20out%20to%20resolve%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2029464%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

I have a Table that contains Product, Purchase date, Quantity Purchased, Purchase price & Market Price.

 

I have created a Pivot Table for this Table.

 

the market Price gets displayed on Pivot table either a sum or Average. My requirement is to have original uncalculated Market price. i do not see any option in Pivot table field settings.

 

Kindly help me out to resolve this issue.

 

Thanks

 

1 Reply

@hemantjshah 

You use PivotTable to aggregate some data, e.g. if in row part you have dates and in value one Qty, you calculate sum of qty per day, month, year, etc. (or other aggregation). Same for market price, you aggregate it for some period of time. As variant you may use min or max of it, or both. That's how PivotTable works, otherwise you need just Table. Perhaps you had other idea in mind, but that's better to discuss on sample file.