Frequency Sales Graph

[#1]

Hey guys.

I needa create a Frequency sales Graph that depicts the frequency of sales over a MonthYear dimension.

I set my expression as

=aggr(Count(MemberNo),Sales)

but its not working.

Any ideas?

Thanks in advanced

[#2]

Maybe vice versa, if you need to see number of sales per Member. The expression should be like this:

=aggr(Count(Sales),MemberNo)

[#3]

Thanks for the quick response.

=aggr(Count(Sales),MemberNo) isnt working...

any other ideas?

[shumailh · Accepted solution]

I think there is no need for aggr() function if you wanted to see the frequency. you just need to define the dimension (i.e. MonthYear) and the expression (i.e. =count(Sales) )

Regards
Shumail Hussain

[#5]

lol cnt believe it...thaks for your help man