Forum

No worries Scotty, glad you figured out a solution. Regards Phil

Hi Maccra, I tried it and it worked for me. I'm using W10 and IE11. If I start IE and accept the T&C's I can then browse the site using PQ....

Hi Scotty, If you Merge Columns in the PQ Editor you can do this. Click on the 2 column headers that you want to merge, then right click one of ...

No worries 🙂

You're welcome 🙂

Hi, Between your 2 posts there just over 90 minutes elapsed. Have some patience, you're not paying for this service, and we all have jobs. It's...

no worries

Hi Richard, You can trap the error that is generated when you try to set the filter to a value that isn't in the source data. When this occurs you...

Hi Richard, I'm still unsure as to where the values for the filter are coming from, specifically for companies that aren't in your source data. ...

Thanks Richard. So what you are saying is that if you have a company '200' that isn't in the source data, you want the pivot table to set the filter ...

Hi Richard, no file attached. A video showing how to attach a file can be found here Regards Phil

Hi Leanne, No file attached 🙁 You need to click on the upload button Regards Phil

Hi Richard, There's not enough info here for me to understand what you are trying to do. If you want to filter a pivot table to only show 100 th...

Hi Robb, With detective work! 🙂 The first thing I did was create a table showing me the errors. You can do this by clicking on the number of ...

Hi Karthink, Please refer to Forum Rules and Guidelines This looks like a homework question. Whilst we are happy to help you if you are stuck, w...