0

Conditional Row Output

I have a simple report, on one tab it shows the sales by customer

On the next tab, I want the report to be by customer- item, but only run if a customer is selected in the options filters

To simplify, I have this report to replicate the problem

I added the following formula

=IF($C$3,NL("rows","Customer","No."),"No report specified")

$C$3 is the (customer no. <> '*'), so if no individual customer is selected '*' then the rows function will not run and the text No report specified is output, if one is selected then it evaluates as TRUE and the rows function will work

However, if we select a customer in $C$3, only one record is returned, not all rows as expected

8 comments

Please sign in to leave a comment.