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