Sales Analysis By Dimension

veeravi

Hi Friends,
While using this features, "Show as lines" is Item,"Show as Columns" is Period and "Show as Values" is Sales Amount, values are appearing, and that's fine.

Here, Is it possible to get the datas/values for the transactions are occured ONLY?. Example, "Show as lines" is Item filed, which means only the Items have the transactions instead of entire Item master and suppressing by zero transactions/values. In the same way for Columns also.

Any way out plz?

RAVI

paddypower

I wish all the NAV Matrix forms could be filtered on values

This can only be done with development. We now use Jet reports with pivot tables to get the results we require (Jet is now free which also help's).

Thanks

PP