Forum

Hi Max, My bad, I misread your request. For the summary table you will have to use a formula like the one below: =SUMPRODUCT(SUBTOTAL(3,OFFSET(N...

Hi Mattias, The Dayorder columns should be in your Date table along with name of day and week of year. You can then connect your DateAndTime15Min t...

Hi M, Welcome to our forum! I recommend you use Power Query to find partial text strings. Hope that points you in the right direction. If you ge...

Hi Beth, You need 4 separate queries here, one for each scenario. The join type will differ depending on the scenario. Have you seen this post whic...

Hi Daniel, Welcome to our forum. In future please be sure to only post your question in one place so that people don't waste time answering questio...

Hi Donna, Welcome to our forum! Your file name contains a percentage sign which prevents it being downloadable by people viewing your question, whi...

Hi Mattias, You should put your fiscal periods in your date table without the times. You may also need this information in your date table with tim...

Thanks for sharing the file, Rick. The date is entered correctly. There shouldn't be any spare/blank rows in the table. This is what's causing the bla...

Hi Rick, Welcome to our forum! Please share your file so we can see what is going on. It looks like the date format in your transactions tab might ...

Hi Max, I think your table is fine and you can enhance the filtering functionality with Slicers for Excel Tables. To fix the count information, you...

Hi Mattias, As Phil said, seeing your file would be easier. It looks as though you have a record in the source data table with no day name or time ...

You can't do this with this technique. If you add a filter (Slicer) for the year it will override the filter on the 'Include Years' column in the Pivo...

Hi Shawn, Please see this tutorial on how to calculate if dates fall between a date range. Mynda

Hi Mark, PivotTables sort by the first column. If you want to sort by date, put the date field in the first column of the PivotTable row labels. ...

Great to hear! Thanks for letting us know.