Excluding values in crosstab

[Former Member]

Hi,

In my crosstab I have Company in rows and I need to exclude some companies in this crosstab.

In Crosstab-expert,for Company, from "Group options", I tried "not equal to" option but, it did not work.

Is there any way to do this?

Regards

Ozan

[Former Member · Accepted solution]

Can't you just use regular ol' record selection??

HTH,

Carl

[Former Member · Accepted solution]

Unfortunately, in my scenario, I am not selecting any value from selection screen. But one specific value has to be excluded from the cross table..

[ido_millet · Accepted solution]

Place the crosstab in a subreport that has a record selection formula that excludes the undesired records.

[former_member292966 · Accepted solution]

Hi,

In your Group Options, set the grouping to Specified Order. You can create your groups. Once you've done that, a tab called Others appears. You will have an option to Discard all others. Select that option and the report will only display the groups you set up.

This is similar to the Group Selection formula.

Good luck,

Brian

[Former Member · Accepted solution]

Thank Brian,

But in the specified orders, we can "include" the values we want. My requirement is to exclude some specific values.

I don't want to include all values except the ones that I want to exclude. Instead, I want to specify the ones that will be excluded.

Is there such a possibility?

Regards

Ozan

[JWiseman · Accepted solution]

hi Ozan,

if you use the suggestion that Fatih provided earlier in the thread you will have success. i use this same method all of the time for cross-tab "filters".

you can then suppress any cells or headers based on them being blank due to the exclusion.

jamie

Edited by: Jamie Wiseman on Dec 23, 2009 3:01 PM

[Former Member · Accepted solution]

Hi Jamie,

Since there is no standard function to exclude values from the crosstab (like in BW queries), I will proceed as you guys suggested. Thanks

Ozan

[JWiseman · Accepted solution]

hello,

the standard function is actually what Carl suggested by using the Report > Selection Filters > Record.

<> "abc"

however, you mentioned that this was not applicable to your scenario....perhaps as this will eliminate the "abc" record from the entire report.

cheers,

jamie

[Former Member]

Hi DerKonig,

You can write a formula instead of KPI like below:

if company = x then formula=0 else formula=kpi

Hope it helps,

Edited by: Fatih Cagiran on Dec 21, 2009 3:37 PM