Hi, Can please someone help me with calculating percentage change (X2-X1)/X1*100 for column Value when grouped by column Category. More specifically, how can get table 2 from table1. | Community

In table 2, the percentage change was calculated separately for each category of A, B, and C. I'm using FME2022.

Table 1

table1 Table 2

table2

Page 1 / 1

You should be able to do this with adjacent attribute mapping in an AttributeCreator

@ebygomm thank you so much. This is a great answer!

Reply