Hi Experts,
I have a Characteristic in the Rows where it will give my Customer details like Name, Mobile No. Etc, and A Key figure in the Columns which calculates the Last/Recent billed date of that corresponding customer.
Now, I want to generate another Key figure where it has to check both the Characteristic and KF and Return a value according to that
For Example,
Name Mobile Last Bill Date(Calculated Key figure) 2nd KF
Customer 1 John 9908123456 20/04/2012 ?
Customer 2 Peter 123 08/05/2012 ?
Customer 3 Mark 9848123456 01/10/2011 ?
Customer 4 K 0000 15/09/2011 ?
Now when user executes the report by giving the input as 20/11/2012 (Cal day) , then value for the 2nd KF should generate as 1,2,3 and 4 for Customer 1,2,3 n 4 respectively.
Logic is, If the customer has Name and 10 digit Mobile No and Transacted with in last 12 Months then Value = 1.
If the customer doesn't has Name or 10 digit Mobile No and Transacted with in last 12 Months then Value = 2.
If the customer has Name and 10 digit Mobile No and didn't Transact with in last 12 Months then Value = 3
If the customer doesn't has Name or 10 digit Mobile No and didn't Transact with in last 12 Months then Value = 4.
Could anyone please guide me.
Thanks in advance,
Regards,
Anil.