Forum Discussion
Complicated Pivot Table Issue With SUMIF like logic.
Alright since I am a new user I can't upload pics. This is a sample set of data: Funding is cumulative throughout the year and not particular to one month. So if it is 2022-03 Funding is 20...
Hello, I tried to do it with power query. Attached is the file... it could fail if it contains data for more than one year...
I think this should be easier with an excel formula maybe a sumifs or something to create the ytd column.