pivot table results

could yopu please tell me why these results vary just becase i moved the columns

CQ-010 Type E 20 2 4
Type F 14 2 4
Type G 8 2 4
Type H 12 2 4
Type J 2 2 4
Type K 2 2 4

total 58

there is a 2 missing from the total

CQ-010 2 Type J 2 4
Type K 2 4
8 Type G 2 4
12 Type H 2 4
14 Type F 2 4
20 Type E 2 4
total 56

thanks steve

Hi,

Your data doesn't make it clear what rows you have swapped. Also you don't say what numbers your are summing.

Is the data suppose to look like this

CQ-010
Type |E |20 |2 |4
Type |F |14 |2 |4
Type |G |8 |2 |4
Type |H |12 |2 |4
Type |J |2 |2 |4
Type |K |2 |2 |4

VBA Noob