L Lisa Mar 17, 2004 #1 Can you create a calculated field in a pivot table that will use the MODE function (similar to AVG, MAX, MIN)?
Can you create a calculated field in a pivot table that will use the MODE function (similar to AVG, MAX, MIN)?
F Frank Kabel Mar 17, 2004 #2 Hi Lisa not directly possible in the pivot table. you may create a helper column in your source data and use this in your pivot table
Hi Lisa not directly possible in the pivot table. you may create a helper column in your source data and use this in your pivot table
A Aladin Akyurek Mar 17, 2004 #3 Did you try to implement what I posted in your previous thread on the same question?
