Report Help!!!!!!!!

[Sridharan]

Hello All,

I'm trying to do a report which somewhat dunno how to do in Business Objects... If someone can throw some light i would appreciate it....

------- -------- -------
Shop ID Visit No Status
------- -------- -------

100 1 2
100 2 4
100 3 5
200 1 3
200 2 4
200 3 4
300 1 4
400 1 3

The above is the visit details of Sales Person to shops...

Now my problem is i want to display list of shops whose status is
equal to a given value as on the last visit to that shop... that is
if i say show the details for shops whose status is 5 then it
shud display all the shops whose last visit status is 5....


one more thing that i'm looking for is, status wise no of shops...
again this shud take the last visit status and count the shops.....like
this....


Status No of Shops
------ -----------
3 1
4 2
5 1



Best Regards,

Sridharan

 

[blom0344]

Hello Sridharan,

You stumbled into one of BO's weakest area's . Whereas in , for instance, Excel you can apply a complex filter , in BO you are limited to applying filters 1 at a time by just selecting a value / values on one column. It is not even possible to apply a standard negative filter ( as in x not equal to ....)

You could define a variable : CHECK_MAX as:

= If <VISITNO > = (Max(<VISITNO >) In <SHOPID>) Then &quot;True&quot; Else &quot;False&quot;

Badly enough, BO forces this variable to become a measure, and measures in BO can't be subjected to filters (but indeed they can be to sorts, anyone ???)

So, if you have quite a list you can move all your candidates to the top of the list and then apply a filter on status.

Yes you are right it does not looks like anything of a solution. Maybe someone has a better offer? T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com