Having Trouble Crosstabbing Data

[Aviator0807]

So I have this table and I want to cross tab it.

Store	Total Sales
A	100
B	200
C	300
D	400

So that I get this table. 

A	B	C	D
100	200	300	400

But what I am getting after using the cross tab and grouping by store is this

A	B	C	D
100	Null()	Null()	Null()
Null()	200	Null()	Null()
Null()	Null()	300	Null()
Null()	Null()	Null()	400

Im not too sure what I am doing wrong. 

[atcodedog05 · Accepted solution]

Hi @Aviator0807 

Configure crosstab like below

Hope this helps : )