Forum

Hi Oli, No file attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the file size before...

Hi Kevin, Please provide a sample Excel file. It looks like you didn't choose the correct column for the values. Mynda

Hi Esteban, Welcome to our forum! Thanks for sharing your file. Duplicate the query, then filter the third column to keep just the rows that con...

Hi Olesea, Welcome to our forum! The error message occurs because it is expecting to find a column called 'Transaction date' in the source files...

Hi Nick, Welcome to our forum! The short answer is, you can't sort by the Show Values As percent columns in regular PivotTables, only the absolu...

Hi Cullen, Go to the Data tab > Queries and Connections. In the Queries and Connections pane that opens you'll see two 'connection only' queries...

Hi Kevin, Welcome to our forum! You need to pivot the description column. If you attach a sample file it's easier for us to help you. If you get...

Hi Twigs, Welcome to our forum! Your data is in the wrong layout for the chart to work the way you want. In the attached file I've unpivoted yo...

Hi Cullen, Welcome to our forum! Obviously this requires a different approach which has quite a few steps, but most importantly, the warnings need ...

Hi James, Welcome to our forum! You would have to use a Power Pivot PivotTable and write a DAX measure to count scores > a certain percentage...

Hi Wim, While the value is in the model, it's not in the model at the level of sales rep, only at the unit level. This means you have to use a work...

Hi Wim, Thanks for sharing your file. I don't see anything wrong with your approach. Not sure why you think there should be a better way. Mynda

Hi Wim, No file attached. Please try again. Be sure to click the 'start upload' button after selecting your file and then wait for the grey check m...

Possibly. However, it's also sometimes helpful to see the key issues in context of the larger dataset (case in point illustrated in the link in my pre...

Hi Jacqui, If you have 365, the sheet is named the same as the query. In earlier versions of Excel this functionality isn't available, so it sounds...