I can't share the actual data because its confidential, but please see excel file with a simple example of the data I have.
All I am trying to do is to get the total number of stores On Target in terms of sales and place that number in a Key Value.
Store - Name of the store
Actual Sales - Sales that have been carried out
Target Sales - The target sales amount or the day
Target Ratio = Actual Sales/Target Sales
Target Reached - This is a calculated item that I created to return "On Target" or "Not On Target" depending if the ratio is >= 1
Thanks
Hello,
There might be better ways of doing this, but I think this should work:
1. Create a distinct count of Store. You could do this by right-clicking Store in the Data pane, selecting New Calculation, and then selecting Distinct count.
2. Assign the new Distinct Count measure from step 1 to a Key Value object.
3. Assign a filter to the Key Value, based on your Target Reached calculated item. Select "On Target".
The Key Value should display the number of stores that are on target.
Let us know if that helps!
Sam
Hello,
There might be better ways of doing this, but I think this should work:
1. Create a distinct count of Store. You could do this by right-clicking Store in the Data pane, selecting New Calculation, and then selecting Distinct count.
2. Assign the new Distinct Count measure from step 1 to a Key Value object.
3. Assign a filter to the Key Value, based on your Target Reached calculated item. Select "On Target".
The Key Value should display the number of stores that are on target.
Let us know if that helps!
Sam
Hi @Sam_SAS
Thanks so much for the assistance.
I am going to give a go this morning, then I will update you.
Kind Regards,
Fungai Jani
Good morning @Sam_SAS
It looks like it worked, thanks a lot for the assistance.
Kind Regards,
Fungai Jani
Great! Thanks for letting us know 🙂
Sam
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.