Restricting data in Business Analytics

afarr
afarr Member Posts: 287
edited 2007-12-05 in NAV/Navision Classic Client
How can I display only non-0 values in a Business Analytics table?

If I display Customer Ledger Entry per Customer by Period, say, then some Customers show only 0's, so I don't want those customers to be displayed. However, if I go to criteria, it only shows dimensions, not measures. (Note that I want to hide a customer only if *all* its entries are 0).
Alastair Farrugia

Comments

  • nazevedo
    nazevedo Member Posts: 2
    Hi afarr.

    To do this you need an visibility agent (in Properties tab) where "formula" must be something like this: "hide Customers when value = 0".

Categories