Hi Frends,
I have created a chart in cognos express.
The user wantes to hide the zero values,meaning that actual's line should finish at 201307 and should not be shown after this.
PFA the output and advise if i can do that
put a filter in your query on Ledger dollars > 0
the problem is value of actual is non zero till 201312, but user wants to see the value to productivity till 201312 and value of actual till 201307(that is till last month0
For this i have used a calculation as follows:
IF
(caption (children([Selected Year])) < caption (firstChild ([This Month])))
THEN
([Actual])
ELSE
(null)
and the query uses slicer functions instead of filters as its cube data.
:( Any other way of doing it?
filters and slicers are two different things, you can have both filters and slicers
my idea would be to create two queries, one for each measure and for the Ledger dollars query put a filter of > 0
then create a third query as the union of the two