Forum

Hi Max, That file you attached (rolling-hour_peak-hour-2.xlsx) doesn't have any formulas in it. Mynda

Ctrl+0 hides, but I thought the question is what shortcut unhides columns. I don't know of any shortcuts to unhide columns, but like Clark suggests...

Hi Lea, I don't know of any shortcut for this. There is a list of column and row shortcuts here. You'll see there are ways to group and ungroup row...

Hi Max, Please find the attached file that summarises the data in a PivotTable (chart sheet), then uses SUMIFS to aggregate the data into a rolling...

Hi Mark, You ask some great questions 🙂 Currently there's no way to apply a color format with a DAX function, but you can vote up the idea on ...

Hi Azri, I'm afraid your problems are caused by the wrong source data layout. Ideally your data should be in a tabular format because this makes it...

Hi, Have you read this article? With Outlook you can add an attachment like so .Attachments.Add PDFFile but that statement is out of context...

Hi Mitul, Try this: =GETPIVOTDATA("Value",$G$1,"MONTH",TEXT(DATE(1904,ROW(A1),1),"mmmm"),"Year","2016") You have to give the text function a da...

Or you can just add the weekly grouped field to the row/column area and use Slicers for the Month/Year filters. You don't have to have the Month/Year ...

Hi Marjorie, I'm a bit confused about what you're trying to do. If you want to duplicate an existing query you can do so via the query editor. Righ...

Hi Lea, The employee can type the value in cells that also contain a data validation list, they don't have to choose from the list. If they type so...

Hi Mitul, The ROW function returns the row number, so in your formula: =GETPIVOTDATA("Sum of 2016",, "Order Date", ROW(F22), "Years", 2016) I...

Hi Mitul, You need a calculated field. See file attached and tutorial below: And for your understanding, here is a tutorial on Calculated It...

Hi Carolyne, You can't get Access files (.accdb) from a folder. You can only connect to an Access database and query the tables and queries in the ...

Hi Carolyne, Yes, you can join the two tables together based on the accounts present in the list of accounts. There are lots different joins and th...