Last seen: Aug 24, 2025
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.
On the first point, I'm pretty sure that the dashboard in the video contains a formula that comes even close to the 8K character limit for formulas. S...
Without seeing the data and the desired output it's difficult to comment on alternative solutions. Though it indeed makes sense to have one entry for ...
Glad we worked that out!
Yes, let's forget about VBA for now. I believe the attached (very crude) PQ solution does what you have in mind.
You can transform the list of texts to a list of numbers by wrapping the Text.Split in a List.Transform function. Table.AddColumn(Source, "Select...
I believe you missed one short sentence in the video that isn't included in the text script. At about 3:42 into the video, Mynda says: "By the way, if...
Can you please give a clear example of how the "1 cell" may relate to "what ever tab it relates to"? Perhaps you can upload a file as well to clar...
Thanks for the file. I see a few odd things going on in the Budget sheet. You renamed the Sub-categories column to MinorCategories (cell C3) and added...