Reeza, the rewards points can be redeemed anywhere; however, they are issued at the restaurants - We want to calculate the redemption rate based on where the rewards are issued  ... View more

Hello Shannon I did try your formula; however when I include multiple categories I am not get the right variance. Thanks  ... View more

To complement what @ShannonMoore said, you would need to derive the equivalent of Shannon's Sales Rep Actual and Sales Rep Target. In your case, those would be Profit CY and Profit PY, defined respectively as:   IF Current/Previous Year Flag = CY RETURN Profit ELSE missing   IF Current/Previous Year Flag = PY RETURN Profit ELSE missing   Best, Renato ... View more

This approach works fine for a year over year. If I want to get a week over week view, what would be the best approach. Thanks  ... View more

Hi, have you tried defining a calculated item with the current date with the needed fotmat? Greetings Silvia ... View more

Hi Chris,   My 5 cents:   You can create a distinct count of customer Number category. Splits the active/inactive customers in 2 different categories (set the other part of a category to missing value) Create distinct counts on those categories   Create a new aggregated measure like this:   Distinct [_ByGroup_] ('Active Customer Number'n)  / Distinct [_ByGroup_] ('Customer Numer'n)   This should give you a percentage active customers.   ... View more

Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existant constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values. This link https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 shows how to turn a SAS dataset into data step code to recreate your data. Post that or a text (.txt extension) file with the results. If the data file is large you can use the OBS option, either system or data set, to restrict the number of rows resulting.   With that you have a better chance of getting tested code or more complete ideas. ... View more