[Answered]Filter rows in dimensional report

[Ammus1234]

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.

[MFGF]

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.

[Francis aka khayman]

If you really need to use a list perhaps this can help:

http://cognosm.fm3online.com/uncategorized/filter-not-in-display/

[Ammus1234]

Thanks MFGF  :)
It is a crosstab in the original report.

[MFGF]

Thanks MFGF  :)
It is a crosstab in the original report.

Did the filter() expression in a calculation give you a working solution?

MF.

[Ammus1234]

Yes it works  :)