Last seen: May 6, 2025
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.
"Jan" can be any date from January 1 through January 31. Add 90 days and you end up at March 31 (Mar) and April 30 (Apr). With 45 days this would be F...
With all due respect, I mentioned I wouldn't be able to answer immediately. So please do not be impatient. My involvement here is voluntary and only w...
The system isn't working with me today and I obviously wanted to write in post# 6: "A regular pivot table can not handle ..." I'll get back to y...
A regular pivot table can handle such Current YTD totals. You'll need to write a DAX measure in Power Pivot for that. I'm on Mac right now and not clo...
OK, looked at the file. But I do not see a Running Total anywhere, so I don't understand the question.
I noticed three same files in the attachments and tried to remove two before answering. All three are gone now. Can you please upload one again. Sorry...
Perhaps like in the attached file, wit the help of Power Query as suggested by Anders.
Could you upload a PDF and the Excel file that connects to it? Difficult to analyse the issue, otherwise.