I am having an issue creating a bar chart based on the requirements. Basically I have some data stacked on top of each other, and based on the dates, I need to count the accounts that added each month, the accounts that are dropped each month.
I am getting stuck when I have to write an expression that compares the dates and look at whether the account exists or not in that month. I began using the Today function and the InMonth function but I realized that this will not work unless it is during an ideal situation where each month the data is loaded on the 30th.
I have attached an excel file with some dummy data and a qvw file with the bar chart and the two expressions that need to be filled in the end (Added & Dropped)
Any help would be greatly appreciated.