Hi all, I'm sure this is not the first time someone has posed this question, so here is my challenge:
I was able to use the Random function to get a specific number of Random values. All was good, except, this applies to the entire data set. What the customer wants is to get the specific random samples by branch. I have tried to apply the 'FOR' clause and got an error. I have tried to 'Group by' , I even tried Page Breaks, and it doesn't give the sample size by Branch.
Here is an example of my statement that works: rank([Random Number]) < 10
Again, this works fine for the entire set of data, but I need to return 9 random samples for EACH branch.
This does not work; rank([Random Number] for [Branch])
Any suggestions?
------------------------------
Stephune Waites
------------------------------
#CognosAnalyticswithWatson