How to suppress crosstab totals < 3 1

[willz99ta]

Hi and thanks for your help,

Is there a way to suppress crosstab rows where the total is less than 3?

Thanks again,
Will

 

[lbass]

Please explain the setup of the crosstab--row, column, summary.

-LB

 

[willz99ta]

Sure thing, here is a look:

The crosstab is organized like this:
(Name) (Total) (Col 1)
(Item Num)(Total Dstct Cnt of PONum)(Qtrly Dstct Cnt PO Num)

I am trying to suppress every row where the Total is less than 3.

Thanks again,
Will

 

[lbass]

If it is really simply a crosstab with a row field and two summaries, then I would just set this up as a manual crosstab, where you group on item and insert distinctcounts on po# for the total and on a formula for the quarterly number:

if datepart("q",{table.date}) = 1 then //first quarter
{table.po#} else
tonumber({@null})

...where {@null} is a formula that you open and save without entering anything. Remove the tonumber() if po# is a string. Not sure what quarter you are looking for--you could compare the field with, e.g., datepart("q",currentdate).

Then you could just use a group selection formula (report->selection formula->group):

distinctcount({table.po#},{table.item#}) > 2

It is actually sometimes difficult to suppress rows conditionally in inserted crosstabs.

-LB

 

[willz99ta]

perfect