Pivot table horizontal split

EduPAz

Board Regular
Joined
Mar 18, 2017
Messages
69
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Hi,

Can someone please help me with this doubt:

I have a pivot table with these characteristics:

- The columns are the months from January to December.
- Each columns (month) has two types of products (A and B)
- I have two rows (R1 and R2)

I would like 2 columns like this:
- For R1, Sales in Januray for Product A. Sales in February for Product A, Sales in March for Product A.... Sales in December for Product A
- The same for R2


Can this be done in a pivot table? I only got an horizotal total (product A and B). I am not able to see a horizontal total split in 2 (product A and Product B).

Thanks!

Andres
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Do you have the source data? If so, is it in a normal format (dates in one column) or separate columns for each month?
 
Upvote 0
Yes, I have the source data. All dates are in one column
 
Upvote 0
This?

LON6mHF.png
 
Upvote 0
Jan
Jan
Feb
Feb
A
B
B
B
R1
R2

<tbody>
</tbody>

It would be something like this.

The pivot table field list should be like this:

-Column labels: Date, Product
-Row label: Type (R1 and R2)
 
Upvote 0
What does the source data look like? It might be in a matrix form that should be converted 1 to 1 first.
 
Upvote 0
The source data looks like:

Column A: Date
Column B: Type
Column C: $Values
Column D: Product

The pivot table field list that I have is like this:

-Column labels: Date, Product
-Row label: Type (R1 and R2)
-Values: $Values
 
Upvote 0
Yes!
Using that configuration, How can I get a Total for Product A and a Total for Product B?
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top