Last seen: Jun 14, 2025
Perhaps Power Pivot can do this. Am on my way out so can't spend time on it right now. Sorry.
Added a rather crude query and loaded it to Sheet2, comparing it with the desired output. I believe that's what you need, although the row and column ...
Can't really see how a pivot table and a slicer can achieve what you want in that exact format.
I created something in PQ. Let me know if that's what you had in mind. Beware that I determined the current year (=dropdown) status based on comparing...
I see what you want to do. Give me some time to think about it.
The file you intended to attach didn't come through. Please try again and don't forget to press 'Start Upload' before you submit your reply.
"However, the Contingency lines should not be circular, in that they do not calculate off of themselves. Contingency, Acquisition only references the ...
I don't think there is a way to avoid circular references here as you attempt to calculate a contingency as a percentage of a total that, in turn, sho...
No worries!
This is what I see when I connect PQ to the CSV, columns A and B. It all seems to line up pretty good, though it probably need som work to clean it up...
Understood!!
The CSV didn't come through. Please try again. This time don't forget to press 'Start upload' and wait until it's complete before submitting your repl...
What exactly do you mean by text in "wrap" format? Can you upload and example of a CSV file with such data?