Last seen: Apr 28, 2025
Can't really tell what you accidentally may have or have not done, though you can drag the sub-categories in any order you want. Then you sort them ma...
@georgeradvansky I would add the Year and Month in both the Budget and Transactions tables before appending them into the Data table. See attached. ...
I couldn't really follow your approach and can't answer the question. But I understand what you are trying to achieve and suggest you simplify the for...
@georgeradvansky Hi Jiri, I would really need to have a look at your file again, otherwise I can not see what you have done.
@rennae Well, how did the transaction get in there? Let's have a look at January for Loan. There is an entry on 13 Jan for 113.34 and another on 2...
I've looked at the transactions data and conclude that the total spending of living expenses is indeed $20,596 as included in the report section. "Cat...
Yes, now I see the table. Thanks. First of all, why does it have the csv extension when it is not a csv file? After ignoring a warning message, Exce...
@georgeradvansky I don't see the file. Can you try again?
Difficult to help without looking at your file. Could you upload it? Just remove any private and confidential information.
Glad you worked it out either way!
I notice that you have applied conditional formatting to color negative variances red and white for cells that equal zero. The latter you don't really...
See if the attached solution tackles your problem. Not sure I fully understand your case though. I added a calculated column that functions like a ...
Your file links to another one on your own system ([Master Project Dashboard Rik Update DO NOT DELETE.xlsx]) so I can't see what's being picked up by ...
Thanks for the file, but I can't really help without seeing all of the underlying data. I.e. the json file. I can double click on an item in the pivot...
The file did not come through. Please try again and press 'Start upload' (and wait until it is complete) before submitting your reply.