Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Use {<1-$>} in the set analysis.
Kiran.
I would use "select excluded" as an action in a button applied on the dimension.
Regards
Norbert
Hi Norbert,
How should i do that?
Thanks and Regards,
Manikanta
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
Try this
Sum({<FieldName=E(FieldName)>} Field2)
Which give sum of the field2 values by excluding the selection made FieldName filter.
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