Powerpivot does not group data per column

[Engell]

Hi,

I have a problem with my pivot table

I have hundreds of sheets to compile regularly, each sheet corresponds to an accounting account and has following columns of information: year, account, account number, text, amount.

I want to pivot my information as follows

	Column Labels
	2014	2015	2016
Category	Sum of amount	Sum of amount	Sum of amount
1	50000	110000	100000
2	100000	220000	200000
3	150000	330000	300000

<tbody>
</tbody>

However I get this

	Column Labels
	2014			2015			2016
Category	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount
1		50000			110000			100000
2	100000			220000			200000
3			150000			330000			300000

<tbody>
</tbody>

And I cannot group the information.

Switching columns and rows does not bring any help either.

What I’m not considering?

Thanks in advance for your help
Hi,

I have a problem with my pivot table

I have hundreds of sheets to compile regularly, each sheet corresponds to an accounting account and has following columns of information: year, account, account number, text, amount.

I want to pivot my information as follows

	Column Labels
	2014	2015	2016
Category	Sum of amount	Sum of amount	Sum of amount
1	50000	110000	100000
2	100000	220000	200000
3	150000	330000	300000

<tbody>
</tbody>

However I get this

	Column Labels
	2014			2015			2016
Category	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount	Sum of amount
1		50000			110000			100000
2	100000			220000			200000
3			150000			330000			300000

<tbody>
</tbody>

And I cannot group the information.

Switching columns and rows does not bring any help either.

What I’m not considering?

Thanks in advance for your help

 

[gazpage]

Where does "Category" come from? I can't see it as one of your columns.