Forum

Hi Patrcia, It's difficult to troubleshoot without seeing the query and files. It's particularly odd that some data comes in but not all. I won...

Hi Charles, There are a few ways to tackle this and depending on which version of Excel you have, there are also some functions that you can use. ...

Hi Filipa, It's difficult to be specific without seeing your file, but have you watched lessons 9.06 - 9.08 on the ALL, ALLEXCEPT and ALLSELECTED f...

Hi David, The only way to remove blanks from Slicers is to ensure they don't show up in the PivotTable, and you can do this by filtering them out. ...

Cheers, Todd. I think this is probably a candidate for a recursive lambda function, but I didn't have the headspace to write it last night!

Hi Todd, Thanks for clarifying. I simplified it from this: =IFERROR(VSTACK(FILTER(FILTER(DROP(SORT(UNIQUE(TOCOL(D60+DROP(REDUCE(0,E60-D60,Custom...

Hi Lori, Welcome to our forum! Please upload an Excel file with some dummy data, the PivotTables and a mock-up of what you'd like to see so we c...

Thanks for clarifying, Todd. That sure is a doozy! I couldn't follow how you're supposed to fill out the flexible working table to trigger the formula...

Hi Rose, The issue is that you haven't changed the date data type using 'change type using locale'. Please read the file called 'Read me first' t...

Very nice, Todd. I'm not sure where the 9 day fortnight column is that you're referring to. Here's a tip for conditional formatting: This formul...

The dynamic named ranges refer to the CUBE formula table, not the source data. You then use those names in your chart, as explained in the tutorial ca...

The dynamic named ranges are for the data that feeds the chart so that as you add more months to your source data, those should feed thorugh to the CU...

Hi Rik, Welcome to our forum! Please try uploading again. Be sure to click the 'start upload' button and wait for the grey check mark beside the fi...

Hi Bax, There's no native way to connect. You can either write your own FTP scripts to download the files from the FTP server to a local folder, or...

Hi Ashley, The SharePoint connector is only available in Excel 2019 or 2021 Professional Plus or with a Microsoft 365 Apps for Enterprise license. ...