Last seen: Jul 8, 2026
I took a closer look at the Entries table and am confused. Let's have a look at 133/Colin. in May-22 I see three rows. Income 85 and Expense 5 Mon...
Create a small table with the column names in the correct order. Connect to it with PQ and create a list of it. Then you can replace the entire part b...
Thanks. Even though I'm an accountant myself I have a hard time figuring out what you are trying to do. For instance, where would the amounts for "Amo...
Thanks for the file. Tried to open it on my Mac but did not succeed. Tried on a PC and could open the file, noting that it it's in viewing mode. As so...
Please try adding the worksheet again. Don't forget to press "Start upload" before you submit your reply.
Hi Bettina, That's difficult to answer without seeing what you have created. On a Mac myself and can use slicers on Pivot Tables and Charts. No pro...
This can be done with a technique I picked-up not too long ago on I've applied that into the attached file for a small example in a one co...
Thanks for the file. I made some changes to make it dynamic, keeping most of the queries you had already prepared. Note I added a small table in a Par...
I believe you forgot to press the "Start upload" button before you submitted your reply. Please try again.
That shouldn't be much of a problem. Please upload a file that looks like your real one, before removing and renaming columns. Replace any confiden...
Aha! I had not seen that the Report tab contains pivot tables due to all the fancy formatting, but now I do 🙂 All your pivot tables filter our two...
What do you mean? Isis Swansea is on row 73 in the first pt and in column BU in the other. Though, you haven't put any data in either of them. They ju...
Hi Dana, Have a look at the attached example. I created a table with 10 columns containing some random numbers. Then a smaller table containing a l...
As far as I know, you can only round number columns in PQ. So you need to change the data type for the Date/Time column to Decimal Number, then round ...
Hi Jack, It's not at all obvious what's going on. When you change the format for User K in the Raw Data to Number and display plenty of decimals, y...