1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Curly Brackets in Pivotby formula (multi-sort)

Hi All. Hoping someone with insight knows what I am missing with the pivotby formula error I am getting.

I have this formula below I am using for this table I am building.

=PIVOTBY(HSTACK(Budget!$T$4:$T$499,Budget!$D$4:$D$499,Budget!$C$4:$C$499,Budget!$W$4:$W$499),,HSTACK(Budget!$L$4:$L$499,Budget!$P$4:$P$499,Budget!$S$4:$S$499),LAMBDA(x, SUM(x)),3,2,{-1,-6,-3},,, (Budget!$B$4:$B$499=$C$1)*(Budget!$U$4:$U$499<>0))

It works without the curly brackets just fine. However, using the curly brackets for the sort order then give me a #VALUE! error that I can’t seem to figure out. I’ve seen other videos where they say this works but not for me. I can use sortby but it doesn’t do the sort inside the table itself.

Anyone know how this works or what I’m missing? It’s the last piece of getting this figured out and I’m hitting a wall. Thanks!

submitted by /u/TypicalFinanceGuy
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#formula generator
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives
#PIVOTBY
#HSTACK
#LAMBDA
#SUM
#curly brackets
##VALUE!
#multi-sort
#sort order
#Budget
#table
#sortby
Curly Brackets in Pivotby formula (multi-sort)