How to use distinct function .

[narender123]

Hi All,

My current expression is :

=Count({<flag={1}>}distinct filer)

This distinct will work for monthly basis as my dimension is month wise.But I want this distinct function based on Yearly basis with the same monthly dimension.How i cant achieve this.

table:

Column      No of Filer

-----------------------------------------

Jan2014               3

Feb2014              4

Mar2014              5

Apr2014               6

-

-

Dec2014            15

Thanks,

Narender

[Anonymous]

try to use aggr function and use year on aggr

[narender123]

Pls tell me the format

[#4]

Hi,

Please try the following

Count(TOTAL <Year> {<flag={1}>}distinct filer)

Regards,

Joshmi

[narender123]

Hi,

Its showing data, total on each month is the same.

So not working.

Thanks

[narender123]

Aggr is showing wrongly data as data for against all month is showing same . So total count on each month is same.          

[Peter_Cammaert]

You can use an AsOf table here. Simple and powerful. There are other solutions if you could drop the DISTINCT clause...

See attachment.

Peter

[narender123]

HI Pater,

where is the attachment??

Thanks.

[narender123]

HI all,
Any one know how to sort out this???

Thanks

[tresesco]

People might help sort this out faster if you could create a sample excel/qvw explaining expected output.