Hello,
In a crosstab with a single column (Year) and multi Summarized Fields (for example : # Dogs and # Cats), is it possible to suppress a line when the values for each year is Null (or Zero).
With this data :
Year Dogs Cats
2008 5 Null
2009 2 Null
2010 3 Null
crosstab =
2008 2009 2010
Dogs 5 2 3
and no line for cats (always Null value).
I tried 'suppress empty rows' (Customize style), but the line is not suppressed.
May be because in my case, the fields #Dogs and #Cats are 'Running Totals'.
Thanks
In a crosstab with a single column (Year) and multi Summarized Fields (for example : # Dogs and # Cats), is it possible to suppress a line when the values for each year is Null (or Zero).
With this data :
Year Dogs Cats
2008 5 Null
2009 2 Null
2010 3 Null
crosstab =
2008 2009 2010
Dogs 5 2 3
and no line for cats (always Null value).
I tried 'suppress empty rows' (Customize style), but the line is not suppressed.
May be because in my case, the fields #Dogs and #Cats are 'Running Totals'.
Thanks