Ed has attended:
Excel Intermediate course
Excel Advanced course
Pivot Tables
Good afternoon,
2 questions with relation to Pivot tables please;
1) How do I create multiple columns of the same data. For example on the course we were shown how to create 4 columns of sum of sales?
2) how do I filter out the zero results from a data set in a pivot table?
Thank you
RE: Pivot Tables
Hello Ed,
Thank you for your question. Here are some steps:
1. Creating Multiple Columns of the Same Data
To create multiple columns of the same data, such as four columns of the sum of sales, you can follow these steps:
Add the Data Field Multiple Times:
Drag the “Sales” field into the Values area four times.
Each instance will be labelled as “Sum of Sales”, “Sum of Sales2”, etc.
Rename the Columns (Optional):
Click on each “Sum of Sales” in the Values area.
Rename them to something more descriptive if needed.
2. Filtering Out Zero Results
Click on the drop-down arrow next to the field you want to filter.
Select Value Filters > Does Not Equal.
Enter 0 and click OK.
This will exclude any rows where e.g. the sum of sales is zero.
I hope this helps.
Kind regards
Marius Barnard
STL
