Hiding Rows where all counts are zero

[Jembo]

I am using BO 6.5.
I have a crosstab showing the Customer Name and Usage Type on the left (1st Measures), and across the top are Months (2nd Measures).
The months displayed are determined by the date range that the user selects.
Is there a way of hiding all the rows where all of the date measures are zero?
i.e.
----------------------Mth1------Mth2-----Mth3
Cust1-----Usage1------60--------50-------0
Cust1-----Usage2------10---------0-------0
Cust1-----Usage3-------0---------0-------0 - Hide this row
Cust2-----Usage1-------0---------0-------0 - Hide this row

 

[Jembo]

Sorry - my brain has gone soft. 1st Measures and 2nd Measures should read 1st Dimensions and 2nd Dimension.

 

[blom0344]

Create variables for all columns in crosstab:

S1: =<Quantity> Where (<Month>=1)
S2: =<Quantity> Where (<Month>=1)
... ...........................

Create variable 'Check' :

= If (<S1>+<S2>+<S3>+....< 1) Then 0 Else 1

Now put a rank on dimension Customer based on measure check for top1 values. This will suppress those rows that are totally empty....

Ties Blom
Information analyst

 

[blom0344]

Even better, just build checking variable as:

= If Sum(<Quantity>) In (<Customer>) < 1 Then 0 Else 1

And base the rank on this checking measure....

Ties Blom
Information analyst