Filtering blanks on Analysis Views

roscouk
roscouk Member Posts: 4
edited 2010-07-07 in NAV/Navision Classic Client
Firstly hi, I have used this forum for reference for years but this is the first time I have posted.

I have an issue where I want to filter to show only entries in an analysis view which have entries.


ie we list all the customers in the analysis view then filter on type "hotel" as a dimension, which only shows values for customers categorised as hotel.

but I want to hide all those which are blank. Is there an easy way to do this

thanks

Ross

Comments

  • Albertvh
    Albertvh Member Posts: 516
    Hi Ross,

    Try to use this <>''


    Albert
  • roscouk
    roscouk Member Posts: 4
    Hi Albert

    It does look and sound like a simple solution, but the analysis view does not allow this filter nor does the <>0 filter work,

    I' am hoping it does not need code to fix this problem, but it may.
  • Albertvh
    Albertvh Member Posts: 516
    Hi Ross,

    Sorry misunderstood what you were getting at. I don't think that without coding you can do this :( , you are trying to hide customers with a zero value.


    Albert
  • roscouk
    roscouk Member Posts: 4
    Hi Albert

    yes that is correct hide customers with Zero value

    Looks like I will have to get some development done

    thanks

    Ross
  • ssingla
    ssingla Member Posts: 2,973
    This is a standard feature in the Matrix though in printing the analysis report, blank lines can be hidden using the property "Show"
    CA Sandeep Singla
    http://ssdynamics.co.in
  • nerve
    nerve Member Posts: 13
    Hi ssingla

    Where can you find this option? in the show option there are only four values :

    Actual Amounts,Budgeted Amounts,Variance,Variance%,Index%

    Kindly let me know ..its urgent
  • nerve
    nerve Member Posts: 13
    Hi guys

    Any help regarding this issue?

Categories