Making Filter as Inverted.

[#1]

Hi All,

         I am having a filter which has 100 entries suppose.I want to view 90 entries data only in the report.I want to select those 10 entries in the filter and i want to see the data other then the selected entries data.i.e., i  want to make filter as inverted filter.Is there any way to acheive it?

Thanks in Advance,

Manikanta

[#2]

Use {<1-$>} in the set analysis.

Kiran.

[Anonymous]

I would use "select excluded" as an action in a button applied on the dimension.

Regards

Norbert

[#4]

Hi Norbert,

                 How should i do that?

Thanks and Regards,

Manikanta

[Anonymous · Accepted solution]

Manikanta,

you create a button, go to Actions

Add "Action Type" Selection, Action "Select Excluded"

then select the Field you want to apply it to.

Regards

Norbert

[CELAMBARASAN]

Try this

     Sum({<FieldName=E(FieldName)>} Field2)

     Which give sum of the field2 values by excluding the selection made FieldName filter.

[#7]

Hi All,

           Thanks for the reply.I have found some other way to achieve this.Create a list box object right click go to properties -> caption -> special icon - > check the selectexcluded icon. and apply

This would solve my problem

Regards,

Manikanta