0

Summary Sales By State

I would like to create a summary jet report which shows the total sales by state for a date range. I can get a list of the states from the customer table with =NL("Rows","Customer","State") , but I can’t figure out how to join the customer ledger entry table in without showing each customer in a separate row. I would like just one row per state, and have the drill down to NAV available.

Thanks.
Sara

3 comments

Please sign in to leave a comment.