Hello Board: I have created a dynamic crostabulated table using the new XLOOKUP function with SORT and UNIQUE so that I can get dynamic toggle between rows and columns. It worked pretty good. The problem I am having is when I am trying to use SUMIFS to dynamically aggregate both row and column criterias , I am getting an error where I think I am not closing a parenthesis somewhere in the formula. Attached is the link to the file.
As always, thanks for the help.
https://www.dropbox.com/s/xvyyook0uvosyja/dynamic%20arrays.xlsx?dl=0
As always, thanks for the help.
https://www.dropbox.com/s/xvyyook0uvosyja/dynamic%20arrays.xlsx?dl=0