Hello you wonderful people, I am hoping someone to assist with a query that should be quite simple but anything is possible.
I have a data table with a list of transactions that span over years for various contracts.
Ideally in a table, based on a filter that selects Month and Year (not day level) I want to be able to show:
MTD - Sum of all transactions per Contract for the month that was selected.
YTD - Sum off all transactions per Contract from the start of the year selected up until the month selected on the filter
CTD (Contract to Date) - Sum of all transactions per contract from when they first appear to the month selected on the filter.
It must be possible for my users to select different months whenever they see fit and see the changes - and yes sadly it does need to be in a single table format.
As always, any assistance would be really appreciated
Thanks
Chris