The first thing I see is that you have multiple records for each school. For example, School #655, if I set the parameter to be October 2014, Months Open should be 2. However School #655 has 3 records in your data source, 1 for every reporting period so you are going to see 6 (2 months * 3 rows of data). You can set Months Open to average (which would give you: (2+2+2)/3=2) but depending on what you are doing you may have to do a bit more. For this table it would work fine.
Open 18 Months:
You can create a calculation that says:
DATEDIFF('month', [Date Opened],[Reporting Period] )
This will tell you how many months a school has been opened up until the reporting period. (not up until the date you selected, so for each year it will change properly). From there you can just make it a boolean to check if the calculation is greater than or equal to 18:
DATEDIFF('month', [Date Opened],[Reporting Period] ) >=18
(or a parameter of how many months you want!)
Check out the attachment to get some ideas!
Revenue per Sq Ft-Q_KR.twbx 2.1 MB
Thanks for your help. You mentioned an attachment but here is none.
Hmm, that's weird that you don't see the attachment... I copied the link it generated, maybe you can get to it that way?
thanks for your help