Cognos 10.1 - Filtering a data Item or member - Report Studio

member cognos
Marcelo Abe picture Marcelo Abe · Jul 1, 2013 · Viewed 20.8k times · Source

I need apply a filter over a data item created or existing member. For example, I want filter the 'CA' state where cities have more than 1000.000 people. But this filter will apply only for 'CA' state and not for others states. And the cities aren't showed on the crosstab. Ex:

  State           $ percapita
  CA              2.000.000,00  <---- only this measure is filtered, using other dimension
  TX              1.203.000,00

Regards,

 Marcelo

Answer

tooms picture tooms · Jul 2, 2013

You can create a list in which you put your two item "State" and "percapita". Then, make a right-click on the list and click to "go to query". Then in the left panel click on the "toolbox" and choose the "filter". Put it in the details filters. A new window appears. You can now write your expression like ([State]='CA' and [percapita]>100000) or [State]<>'CA'

Related questions

cout is not a member of std

I'm practicing using mulitple files and header files etc. So I have this project which takes two numbers and then adds them. Pretty simple. Here are my files: main.cpp #include <iostream> #include "add.h" int main() { int …

Read More
invalid use of non-static member function

I have something like this: class Bar { public: pair<string,string> one; std::vector<string> cars; Bar(string one, string two, string car); }; class Car { public: string rz; Bar* owner; Car(string car, Bar* p); }; class …

Read More
C++ callback using class member

I know this has been asked so many times, and because of that it's difficult to dig through the cruft and find a simple example of what works. I've got this, it's simple and it works for MyClass... #include <…

Read More