Forum

Hi Aye, See session 7.08 Add Rows. You can use the List.Number function as described here to generate a list of the facility numbers. I hope th...

Hi Aye, Turn off the Subtotals in the Table formatting pane and create your own using measures. It's the only way. Mynda P.S. In future, can ...

Hi Todd, Sounds like something is up with your install of Excel as I have Office 365 and can see the list of paper sizes, so it's not a new feature...

Hi Leah, It's case sensitive, the formula is Excel.CurrentWorkbook with a capital W. Mynda

Create a dummy PivotTable with just the date field in the value area. Set the aggregation to Maximum. Format the cell as date. Mynda

Glad I could help, Jim 🙂

😀 don't worry, American English use 'spilled'. It's only the Brits that use 'spilt' 🙂

The Timeline Slicer is a bit buggy. Sometimes it will show more years than you have data for, other times it will show the actual years. I haven't fou...

Hi Jim, One way is to duplicate the query and filter the Pge1.Split column to retain rows containing 'Yes', then merge the two queries As New. Or y...

Purfleet is correct. The # range operator only works on ranges that result from dynamic arrays that spill the data. They don't work on any old range.

Converting the data to a Table won't break the formulas. I wouldn't worry about it, but if you insist on not converting them then you would need to cr...

Hi Claudine, The Index column needs to be added AFTER the unpivot. The idea is that it creates a unique identifier for each row. You can then Pivot...

Hi Miguel, Thanks for emailing your file. It's a .xls format which is for Excel 2003. Excel 2003 doesn't have these tools, which is why you aren't ...

Hi Miguel, I think I understand that you're not able to insert Slicers for your PivotTables or Pivot Charts. If you go to the Insert tab do you see...

Hi again! I can't reproduce that problem. It might be a bug in the version of Excel that you have. Maybe you can try updating Excel to see if there...