Filter only certain columns in Excel Pivot Tables

0 votes

I have a table with a list of dispatched and planned order dates that looks like this:

enter image description here

I'm attempting to create a pivot table from this. My problem is that I just want it to be filtered by each specific location (in this case Uberherrn and Willebroek)

The pivot table that results looks like this.

enter image description here

Is it at anyway feasible to restrict the results to simply display the Planned and Shipped columns for each area? The graphic below represents my ideal output, with the ability to modify the Planned and Dispatch columns based on a city filter (to choose Uberherrn or Willebroek to show planned and dispatched for either based on the filter)

enter image description here

Is this possible? I've been trying to figure it out but I can't quite get it right..

Apr 4, 2023 in Others by narikkadan
• 63,600 points
445 views

1 answer to this question.

0 votes

Pivot Tables are mainly designed to create aggregated data from raw data. Your input is already aggreated so no, you cannot benefit from a Pivot Table.

enter image description here

Let's just say it's like a summary report. To benefit properly from a Pivot Table features your data should look like this:

enter image description here

Notice how I was able to create a Pivot Table on the right side based on this raw data, and then filter what values of Field I want to see.

answered Apr 4, 2023 by Kithuzzz
• 38,000 points

Related Questions In Others

0 votes
1 answer

Pivot Tables in MS Excel (Office 365)

If you create the required result table ...READ MORE

answered Nov 13, 2022 in Others by narikkadan
• 63,600 points
737 views
0 votes
1 answer

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Try this: =LET(files,A1:A4, URLs,B1:B4, f,BYROW(files,LAMBDA(r,TEX ...READ MORE

answered Jan 21, 2023 in Others by narikkadan
• 63,600 points
616 views
0 votes
1 answer

Want to compare two columns in excel

Hello To compare two columns in excel ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
1,120 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
995 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,600 points
1,298 views
0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,600 points
864 views
0 votes
1 answer

Use Excel pivot table as data source for another Pivot Table

Press the keys Alt+D+P in a new ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
• 63,600 points
14,509 views
0 votes
1 answer

Excel Power Pivot/Data Model

Here is the answer for your question: ...READ MORE

answered Nov 15, 2022 in Others by narikkadan
• 63,600 points
795 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP