counting non-zero values in cross-tab

[ari_meta]

Hi

   i want to count non-zero values in the cross tab column wise. can any body give me some guidance.

Thanks

Ari

[CognosPaul]

Are you on a relational or dimensional? Either way try something like this:

Code Select Expand

count(1 within set filter([Product type],[Returns]>0))