ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
تاريخ النشر: 2015/04/07
Reynaldo Corvera
من قبل 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
من قبل 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 

المزيد من الأسئلة المماثلة