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

[TABLE="width: 100%"]
<tbody>[TR]
[TD][/TD]
[TD]Column Labels
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2014
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2015
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2016
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Category
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD]50000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]110000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]100000
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]100000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]220000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]200000
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]150000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]330000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]300000
[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 100%"]
<tbody>[TR]
[TD][/TD]
[TD]Column Labels
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2014
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2015
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2016
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Category
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[TD]Sum of amount
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD]50000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]110000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]100000
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]100000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]220000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]200000
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]150000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]330000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]300000
[/TD]
[/TR]
</tbody>[/TABLE]

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.