Help with displaying results which are less than 9999

[hopkinsc]

Hi,

I have a dimension in a PIVOT TABLE called 'EAN', EAN's are barcodes which range from 1 - 9999999999999. I only want numbers up to 9999 to be displayed within the EAN dimension, all numbers above 9999 i want to be excluded from the results.

Can someone tell me how to achieve this please?

Thanks

[Miguel_Angel_Baeyens]

Hello,

It should be as easy as using set analysis in all your expressions

Count({< EAN = {'<=9999'} >} DocumentNo)

Another workaround would be using an IF condition, which will affect your application performance.

Hope that helps

[hopkinsc]

thanks for your reply, but what does DocumentNo mean??

[hopkinsc]

Actually that didn't seem to work. I don't want to count each time there is an instance of 9999 or below.

This is what i want to do...

If for example there are EAN's as below:

23

84

659

954

1002

5010358

5000256336224

5000687448574

9976568852472

I would only want the user to see the EAN's which are under 10000.

[Miguel_Angel_Baeyens]

Hi,

My sample above was just to show how set analysis works and how it should be used with your expressions. I was using "Count()" function based on a "DocumentNo" field and "EAN" field. It would be simpler if you post here an example of what you want to get and actual field names you are using.

On the other hand, if you are pulling info from the database and you mean you only want to get those EAN under 10000, a sample load statement would be

Table:LOAD Field1, Field2, EAN FROM DataSource WHERE EAN <= 10000;

Regards.