Create a new key figure with apply a specific selection
I need to create two calculated key figure within the query.
Available info object : CustName , AccessDate, BillAmt
Key Figure formula:
KF1 = Count the No of CustName where AccessDate is greater than or equal to system date
KF2 = Count the No of CustName where AccessDate is less than system date
note : system date is not available in the cube yet.
How can i create this in the Query Designer on version 7.0