Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Pivot table uses sum by default and returns the sum of your data. if you need to count how many data or to get the average how can you change it?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/04/07
Reynaldo Corvera
par Reynaldo Corvera , Planner , Flexible Packaging

Go to PIVOT DATA FIELDS

in VALUES field- click the item and  value field setting in context menu.

and select Count  to  calculate the number of data or AVERAGE to determine the.

Note: in order the view the two item field. Drag2 filed items in VALUE PIVOT DATA FIELDS

then select COUNT and AVERAGE for other item so that you can view the COUNT and AVERAGE.

 

Atif Tanveer
par Atif Tanveer , Decision Support Specialist , Hamilton Health Science

Right click on in anywhere in PivotTable, click on Value Field Settings..., under tab "Summarize value field by" select Count or Average 

saddam hussain shaik
par saddam hussain shaik , DIGITIZER , APSAC

BY USING COUNT AND AVG FORMULAS

More Questions Like This