Filtering blanks on Analysis Views

roscouk

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

Albertvh

Hi Ross,

Try to use this <>''


Albert

roscouk

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

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

Hi Albert

yes that is correct hide customers with Zero value

Looks like I will have to get some development done

thanks

Ross

ssingla

This is a standard feature in the Matrix though in printing the analysis report, blank lines can be hidden using the property "Show"

nerve

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

Hi guys

Any help regarding this issue?