use of count, where...

[chiso_chiso]

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.

[chiso_chiso]

Attachment

[mato32188]

Hi Harrison,

see attached file, hope helps.

BR

M

[jyothish8807]

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

[its_anandrjs]

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