Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a year filter, if I select 2017, it returns 12 (last month in 2017). If select 2018, it return 5 (current month).
Is that possible?
I think Max(Month) will respond as per your selection and needs
I think U can try count( distinct Month) too