Hello All,
I want to hide the rows in the attached report for which the Quantity is zero. Can I do it without using any detail filters.
Year will be prompt in the original report and I want to show a fixed value for the calculated item (here quantity) for a period even though the yearly value is different.
Sample report is based on Go Sales(analysis) package.
Thanks in advance.
Any help would be appreciated.
Quote from: Ammus1234 on 29 May 2014 03:34:37 AM
Hello All,
I want to hide the rows in the attached report for which the Quantity is zero. Can I do it without using any detail filters.
Year will be prompt in the original report and I want to show a fixed value for the calculated item (here quantity) for a period even though the yearly value is different.
Sample report is based on Go Sales(analysis) package.
Thanks in advance.
Any help would be appreciated.
Cut the current Year level and replace it with a query calculation with the expression:
filter([Year level],[Quantity] is not null)
I would create this as a crosstab not as a list, personally. Lists are inherently geared towards relational data and constructs.
Cheers!
MF.
If you really need to use a list perhaps this can help:
http://cognosm.fm3online.com/uncategorized/filter-not-in-display/
Thanks MFGF :)
It is a crosstab in the original report.
Quote from: Ammus1234 on 05 Jun 2014 03:00:52 AM
Thanks MFGF :)
It is a crosstab in the original report.
Did the filter() expression in a calculation give you a working solution?
MF.
Yes it works :)