Find and double-click your Excel file on your computer to open it. If you haven't made your pivot table yet, open a new Excel document and create a pivot table before continuing. This will select the table, and show the pivot table Analyze and Design tabs on the toolbar ribbon at the top. You can find this tab alongside other tabs like Formulas, Insert, and View at the top of the app window. It will show your pivot table tools on the toolbar ribbon. On some versions, this tab may just be named Analyze, and on others, you can find it as Options under the "Pivot Table Tools" heading. You can find this button on the right-hand side of the pivot table Analyze tab. It will open a list of all the fields, rows, columns, and values in the selected table. This will calculate the summary of your original data in the selected category, and add it to your pivot table as a new column.  Typically, non-numeric fields are added as rows, and numeric fields are added as columns by default. You can uncheck the checkbox here anytime to remove the column. This will automatically move the selected category to the Columns list, and re-design your pivot table with the newly added column.
افتح ملف إكسل المحتوي على الجدول المحوري الذي ترغب بتحريره. انقر على أي خلية في الجدول المحوري. انقر على لسان تبويب تحليل الجدول المحوري PivotTable Analyze الظاهر في الأعلى. انقر على زر قائمة الحقول Field List في شريط الأدوات. فعّل الصندوق المجاور لأي عنصر في قائمة "اسم الحقل". اسحب أي حقل أو صف أو قيمة إلى قسم "الأعمدة".