Create parameters Jan 18, Feb 18 etc. which will become columns with the same value.
For active/inactive users, you can try calculation like
Active/Inactive = If Current Period End>=Today() Then "Active" ELSE "Inactive" END
Then Active Users = IF Active/Inactive = "Active" THEN 1 ELSE 0 END
Inactive Users = IF Active/Inactive = "Inactive" THEN 1 ELSE 0 END
Thanks for the reply Sohan ! Will definitely try the 'parameters dates' !
The problem is that for example a user Who was active from Jan 18 to May 18 (Current period end May 18) will be counted as Inactive and the main problem here is that I want to count him as active in months 1 2 3 4 5 2018 and inactive in months 6 7 2018.