Sorry. i did not explain it, you are correct. I do want to suppress the data if Year 1 = zero. Years 2 and 3 are inconsequential if the first year is zero.
The row is basically akin to a SSN
The column is a group of periods from a year grouped by years.
The summary is the distinct count...
Hello,
I am trying to find a way to suppress a row in a cross tab report based on the value of the first column.
Ex
ID # Year 1 Year 2 Year 3
ID 1 1 1 0
ID 2 0 1 1
ID 3 1 0 0
ID 500 1 0 0
The year columns named groups for three combined periods and the summary is the distinct count of the ID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.