Forum

Hi Miguel, What type of file is it? If you don't already know the country of origin, I don't know how you can tell for sure by looking at the file...

Hi Guanyu, Use the Custom Lists as I described to sort your pivot table. By the Way - to upload a file : Under the box where you type your repli...

Hi Guanyu, You can create a custom list and sort your pivot table by that. File -> Options -> Advanced -> Edit Custom Lists and crea...

Hi, I'm having trouble understanding what you want to do but I think it is something like this (Source as table, Col as text, Value as text)=>...

Hi Mikaela, I'm afraid there's no attachment. Did you click on the Upload button? Regards Phil

Hi, It would be much easier if you supplied a detailed example with data in a file. A couple of lines taken out of context are hard to relate to. ...

Hi Terri, Change the chart to a 100% Stacked Column. Regards Phil

Hi Florence, Can you please supply some sample source files for your query to load? Phil

Hi Shirley, Nothing attached, did you click on the Upload button? Instructions here Regards Phil

Hi Aye, I'm not sure what you are asking: 'prepare the data for month with null value'? It's not clear where your source data comes from. You m...

Hi Florence, Welcome to the forum. Your attachments did not attach, did you click on the 'Start Upload' button? Please see here for (video) ins...

Hi Francis, Always best to provide your workbook and data so we don't have to recreate everything from scratch. If your conversion rate is the o...

Hi, I'm not really sure what you mean by 'your way of writing parameter', maybe you could explain more clearly with an example? However, if you ...

You're welcome.

Hi Gokhan, You will either have to use VBA for this, or do it manually by going to the Ribbon -> Data -> Sort & Filter -> Reapply. ...