I was going to leave this but the more I thought about it the more I think my client will like it. I have 3 main columns Fiscal Year 14/15 and reporting period from 1 - 12 and 12 being March. What I want to do is do two counts of column 3 one for the current month and one from the previous month. I want my client to only select which fiscal year they are looking at so if they chose 13/14 it would show what happened in Feb / March 2014 as theses are the month we are in now. Does any one have any ideas or has any one done this before. I must point out when the QV Doc open's it is set to open on current fiscal year so next month will be a comparison of March and April.
