Totals from Crosstab to Transpose to Crosstab change

[hellyars]

I have never run into this one....

Data as Crosstab (start, #1) totals correctly.

Transposing the data changes the total.

BUT, taking the transposed data that totals incorrectly and putting it back to a Crosstab totals correctly again?

I have tripled check the selections in the Transpose tool (they look good).

Huh?

#1 Crosstab Total (Start)

2022	2023	2024
1307651	1642532	2746313

#2 Cross-tab TO Transpose Total

Year	Sum_Value
2022	2746313
2023	2253081
2024	1931118

#3 Crosstab of Transpose Total in #2

2022	2023	2024
1307651	1642532	2746313

Huh?

[binuacs · Accepted solution]

@hellyars I tested the scenario seems to be the values are not changing

[apathetichell]

Turn off AMP engine and retry!

[hellyars]

Yeah.  Embarrassed.

I was focusing on the value column and did not realize the year column sort had changed. 

Everything is good.