0

A matrix of sheets

I want to create a sales report per country per sales type.
So far so good, but for every combination I want a sheet.

Report options give me the ability to select one or more countries and one or more sales types.
Both are from a different table in NAV.
On running the report after I selected the options I end up with e.g. NL,DE,GB as countries and B2B,B2C as sales types.

Now I want 6 sheets: NL-B2B, NL-B2C, DE-B2B, DE-B2C, GB-B2B, GB-B2C.

What Jet function can I use to accomplish this?

I'm kind of stuck on ideas :)

rmw

7 comments

Please sign in to leave a comment.