This should be simple but I'm rather new and wasn't able to find the answer through searching. I'm making a basic report that will show sales people by region using an Excel range as the table source. The desired layout is in the attached workbook but also presented below:
Region 1
Salesman 1
Region 2
Salesman 2
Salesman 3
Salesman 4
Region 3
Salesman 5
Salesman 6
Region 4
Salesman 7
Salesman 8
Salesman 9
Salesman 10
For the first formula, I have the rows function breaking out the sales regions, which works correctly. — =NL("rows=3",Data!$B$3:$B$6)
There is another NL rows formula (below) where I want it to show all of the names in the "Salesman" field, when the "Region ID" matches an adjacent cell. When I run the report it shows everything in the entire range, including the headers, regardless of what the region is:
=NL("rows",Data!$D$2:$E$14,"Salesman","Region ID",B4)
Do need to define the field headers? It seems to be ignoring the part where I only want the salesmen that match the region.
Any tips would be appreciated.
Date
Votes
1 comment
-
Jet Reports Historic Posts hi
pls go through the below link
http://kb.jetreports.com/article/AA-00731/0/
Go through Vedio No -Grouping Report 2
if you require any help get back to me…
Regards
Alex..
Please sign in to leave a comment.