Student1001
New Member
- Joined
- May 24, 2016
- Messages
- 8
I am very new in SQL and the software IBM Cognos and I was tasked as an intern to create a report with a header ((months) 1, 2, 3) and under this header an actual value and a target value.
What I am looking to do is to filter out the blanks in the cells actual and target values under a certain month (eg. month 3), keeping the rest of the row values (so I have data from month 1, 2, and 3) intact.
In other words, if month 3 is not blank, I would like the data from month 1 and 2 as well. If it is blank, I would like to filter it out.
I have been playing around with filters, however, I've been using the and condition (something like month = 3 and not isnull(actual value)) and this only gives me the non blanks from month 3. Some help would be greatly appreciated.
What I am looking to do is to filter out the blanks in the cells actual and target values under a certain month (eg. month 3), keeping the rest of the row values (so I have data from month 1, 2, and 3) intact.
In other words, if month 3 is not blank, I would like the data from month 1 and 2 as well. If it is blank, I would like to filter it out.
I have been playing around with filters, however, I've been using the and condition (something like month = 3 and not isnull(actual value)) and this only gives me the non blanks from month 3. Some help would be greatly appreciated.
