Last seen: Jul 7, 2026
Not the most elegant solution but I believe formulae in the attached file work as intended. I've used a few helper rows (hidden with a group butto...
Perhaps you can upload the file you are working on. Otherwise we'll be guessing what exactly you have changed.
I see what you mean but can't explain it. Perhaps someone else can.
OK!
Can't really tell what the problem is. I've not come across it before. Sorry!
I don't really understand your intentions based on the example you provided and, thus, can not say what DAX measure you would need. If the formulas in...
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Did you look into the SUMIF and SUMIFS functions? IF you did and couldn't figure it out, it would be easiest for us to help if you upload your file...
Well, a pivot table needs something to summarise/aggregate. If there is noting in the Values area, every combination of FN-Year, Status and Assigned c...
Drag something in the Value area anyway, as Velouria suggested. For instance the FN-Year filed. That's a text and will automatically set it to Count. ...
See attached with some small changes in the orange shaded cells. Basically the same as Charles' solution but with a formula for the subnrs in A43 and ...
In response to post nr 10: I used Power Query. If you are new to that, look at the formula based solutions first.
Difficult to judge without seeing examples of the scanned/converted files you are working with.
Check the Refresh settings for the query. Perhaps the 'Refresh this connection ..... ' is disabled.
I agree with Hans that the dates in columns G:K don't seem to make much sense. I guess the are merely examples to show that a payments should show in ...