Help on Pivot Table

[chica17]

Hi! I'm having a problem arranging a pivot table report in a simple layout. Can anyone help?
So, I have a (quite big) set of data in this format:

Client	Department	Employee	1MAT	1H	1OT	1TOT	2MAT	2H	2OT	2TOT	3MAT	3H	3OT	3TOT	4MAT	4H	4OT	4TOT	5MAT	5H	5OT	5TOT	6MAT	6H	6OT	6TOT	7MAT	7H	7OT	7TOT	8MAT	8H	8OT	8TOT	9MAT	9H	9OT	9TOT	10MAT	10H	10OT	10TOT	11MAT	11H	11OT	11TOT	12MAT	12H	12OT	12TOT
A	ENG	3458					0	98,52	0	98,52	86,158	211,96	0	298,154											21,66
A	LOG	3697	69,69	179,24	0	248,915																	21,66	0	4157,715				59,614	0	1597,154					0	141,66	0	141,66
A	LOG	3245	0	21,66	0	21,66									106,66	0	0	106,66						0	141415,4											151514,1	105,48	0	4157,715					164,14	0	0	164,2
B	SUB	3987	15152,25	105,48	0	4157,715																		0	155,157				0	0	16,015					189,78	1515,614	0	141415,4
B	LOG	3719	189,78	1515,62	0	2215,4																		0	511,145	190,5	0	0								0	155,157	0	155,157	1497,415	0	0	1497,415
C	ENG	3547	0	155,157	0	155,157	190,5	0	0	190,5		0	0	0,58	0,58	0	0	0,01	0,01				80,99	0					115,17	0	115,17	15,87	0	0	15,87
D	LOG	3698	4150,26	80,99	0	511,25														27,1	0	0	27,1																	0	118,06	0	118,06	110,514	0	0	110,52
D	LOG	3697	0	0	2,86	2,86	0	0	-0,81	-0,81																	105,48																	0	0,2	0	0,2	197,95	0	0
E	SUB	3821	0	0	2,71	2,71	0	0	0,01	0,01											21,66	0	21,66				1515,614									5140,11	159,76	0	559,87
E	ENG	3978	0	0	15,215	15,215	0	0	0,02	0,02											105,48	0	4157,715				155,157		1488,09	0	1488,09									114146,5	0	0	114146,5			197,95
E	ENG	3147					0	1586,77	0	1586,77					15,4	0	0	15,4			1515,62	0	2215,4						0	7,8	7,8

<colgroup><col><col><col><col span="48"></colgroup><tbody>
</tbody>

In which every number behind "MAT", "H", "OT" and "TOT" refers to a month.
When I build a Pivot Table from this data I put "Client", "Department" and "Employee" in rows and the rest of the columns in values and then I end up having 48 fields in Values, which is terrible for a comparative analysis.
What I need is to have only "MAT", "H", "OT" and "TOT" in values and have the month in filter, for an easier analysis.
Does anyone have an idea how to do this without changing the source data?
All help will be appreciated!
Thanks!

 

[ranman256]

use microsoft query, and produce a sheet of only those months, then run the pivot
or
use microsoft Access and make a query to produce a sheet of only those months, then run the pivot
or
in Excel, filter only those months, then copy/paste to a new sheet, then run the pivot

 

[chica17]

Hi! I used Power Query and was able to unpivot the columns but i created a new problem: I ended up with +3 million lines and I can't seem to be able to export the data produced by the Power Query to the Power Pivot data model (to produce a pivot table from there)