Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Kindly assist gurus,
Attached is my sample data. I want to count totalsales where dateofsale is after 1st october, 2014. secondly, I want to count the number of names that made sales more than 5 regardless of date of sale.
Please assist.
Attachment
Hi Harrison,
see attached file, hope helps.
BR
M
Hi Harrison,
PFA, hope it may help. I made few changes in your data. I changed the names so that I can check for the count of names who made sales more than five times.
Regards
KC
Hi,
For first query
Let Create a variable
Let vSelectDate 10/1/2014;
1. =count({< DateOfSale= { '>$(vSelectDate)'}>}totalsales)
2. Count( if(totalsales >5,Name))
And
By SET expression
Count({< totalsales = {'>5'} >} Name)
Regards
Anand