Forum

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...

Hi Karen, Correct, you should use the Slicer from the dim table, but you should also use the division field from the dim table in the PivotTable, n...

Hi Kelly, Welcome to our forum! I think labeling 4000 data points is probably not very useful. I recommend selecting the points you want highlig...

Hi Graham, Welcome to our forum! Each series' data labels are independently formatted, so there's no default way to ensure the series name is al...