Please add the LET and TAKE functions that exist in Excel.
I have a simple Excel pivot table. I placed a percentage change rows below the pivot table. As a practical applications I was manually updating percentage change formulas for 1 month, 3 month, 6 month, and YTD intervals.
With the LET and TAKE functions, each time the pivot table came up with the next month of data the percentage change formulas would automatically update. REAL time saver.
% change last month =LET(d,TAKE(B5:.B100,-2),TAKE(d,-1)/TAKE(d,1)-1)
% change last 3 months =LET(d,TAKE(B5:.B100,-4),TAKE(d,-1)/TAKE(d,1)-1)
% change last 6 months =LET(d,TAKE(B5:.B100,-7),TAKE(d,-1)/TAKE(d,1)-1)
% change ytd =LET(d,B5:.B100,TAKE(d,-1)/TAKE(d,1)-1)
Thank you for considering