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