Forum

Hi Michalis, Use this formula in cell O6 instead: =UNIQUE(VSTACK(A6:A20,C6:C20,E6:E20,G6:G20,I6:I20,M6:M63),,TRUE) Mynda

Hi Tom, I was assuming you were using VSTACK inside the lookup e.g.: =XLOOKUP(lookup_value, INDEX(VSTACK(...),,1), INDEX(VSTACK(...),,2) ) or...

Hi Jim, I'm not familiar with a way to do this. You might be limited to a Table visual: Mynda

Hi Katherine, You can use Power Query Merge to combine these files similarly to how you might do a VLOOKUP to bring columns E and F into file 1. ...

Hi Tom, Yes, you can feed the result of VSTACK into XLOOKUP, but you'd have to FILTER the VSTACK to only return the relevant column for XLOOKUP's l...

Hi Dieneba, Try: Settings (cog icon) > Admin Portal > Tenant Settings > Integration Settings > Map and filled map visuals > Enable ...

Hi Joanna, I can't reproduce the expanding of grouped columns when I try and link a cell on the 'Link sheet' to the 'FTE & DAYS DEMAND' sheet. ...

Correct, protection like I describe allows the user to select periods in the timeline, but not change the aggregation from days, months, quarters and ...

Hi Guido, Welcome to our forum! Unfortunately, you're not able to have major units in line with month start dates as they are always equally spaced...

Hi Bax, The Excel.CurrentWorkbook function designed for this requires the data in Tables or a named range. The workaround, is to get the data from ...

Hi Ramez, Note: this is an Excel forum, so these solutions are for Excel. There is no guarantee they will work in Sheets. The data validation li...

Hi Joanna, Welcome to our forum! I just tested linking a formula from Sheet1 to Sheet2 which contains collapsed grouped columns and I didn't hav...

Hi Ivan, Thanks for sharing the example file. The bottom 3 options do not need a column to count because they are counting rows grouped by the colu...

Hi James, I don't have any tutorials on cohort analysis (it's a pretty advanced topic), however you might find these posts that relate to custom re...

Hi Jodi, Thanks for the file, however I presume this is not the structure of the data in the fact table. Not only is it not in a tabular layout, it...