Forum

Glad you're getting there, Alan. I guess I didn't understand what you're struggling with because the shape of the chart simply reflects the data, but ...

No idea, sorry, Bax. I dont' know SQL. I'm surprised the query is faster if you enter your SQL code in the advanced settings, rather than using the...

Hi Remy, Welcome to our forum! I don't recommend adding VLOOKUP formulas to the output table of a query. You can get the meta data from the file us...

Hi Jessica, Please upload the file or if the data is sensitive you can upload a sample file that illustrates the problem. Mynda

Hi Alan, A bell curve chart is just a line chart. It's the data that dictates the bell shaped line. Mynda

Hi Johannes, Welcome to our forum! Please upload a small sample Excel file that illustrates your problem and the desired result so we can help you....

Phew, that's a relief!

Glad you got there in the end!

Hi Pieter, Thanks for clarifying and sharing the file. I bet you're wanting to tell your tester to get a PC 🙂 I can't see any reason why loadi...

Hi, I would approach it without using the VLOOKUP because it's not good practice to add formulas to columns in a table that is the output of a quer...

Hi Ralph, In Power Pivot you can write measures. Please see the attached file to see if that's what you want. Note: I'm a bit confused because y...

Hi Pieter, You didn't say what the error is, so it's difficult to say. However, presumably there aren't any queries that are directly referencing t...

Hi and welcome to our forum! You can also see if there are errors in the Queries and Connections pane. Go to the Data tab on the Excel ribbon > ...

Hi Lukasz, Thanks for clarifying. I think there is an error with example for article 9913 because this should be month 6 of 2022, assuming the mont...

Hi Lukasz, If it's pivoting you need, then won't a PivotTable do the job? See attached. Note: I don't know what M_3, M_4 etc. relate to. You may ne...