Sort by expression in pivot with a macro

[#1]

Hello everybody

I'm working with pivot table with years and quarters pivoted and need to sort by expressions

The expressions i have: amount and an annual growth rate, I can sort by any amount but not growth rate

The main doubt i have is, can i use 'ColumnNo()' function for using in a SortByExpression in macros ??

Why this function? To calculate de annual growth rate

Apparently this does not work, any ideas ??

I attached the sample, thanks in advance