Last seen: Jun 16, 2025
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 ...
That may make sense as the criteria can be be set to match or not. The latter, though, requires a special syntax. For example: =SUMIFS(B1:B100,A...
Great! That's a small mistake. Do it once and never again 🙂 You can always hide the customer id from the fact table so that it doesn't show in the...
Did something in Power Pivot. Loaded both tables to the DM with a relationship on the Customer ID. Two simple (tough explicit measures to sum appointm...
Could you please upload a file with some example data in both tables and the expected result you want to achieve?
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Such a time stamp would require a change event in VBA or a formula that requires iterative calculations (File, Options, Formulas, ....) VBA is not ...
Difficult to judge. When you say "billing reports" are these summarised reports by month/week or do these also include the individual invoice records?...