Topic: Select Multiple Level 2 dimensions for report?

Hello,

Say Dimension 1 is a location level, then Dimension 2 has departments within that. If this was a car dealership, maybe the Dim 1 is a location, Dim 2 has "Parts Department", "Service department", and "New car Sales department".

Is there any way to run a report that is on a Dim 1 location, and BOTH the Parts and Service departments, or do I manually need to run a Parts report, and  a Service report, and manually combine them?

Re: Select Multiple Level 2 dimensions for report?

What happens if you run a report only selecting the dimension 1?

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

Re: Select Multiple Level 2 dimensions for report?

Only that Dimension will be filtered.

Re: Select Multiple Level 2 dimensions for report?

@ Poncho1234, If I run based on only Dim 1, it would capture all three Dim 2 level items (Parts, Service, and New Car).

The data I desire is generated by running a report on Dim 1 Location and Dim 2 Parts, then another report of Dim 1 location and Dim 2 Service, and manually adding both reports together. I'm just looking to see if there is a trick to getting FA to do it for me directly.

5 (edited by poncho1234 01/11/2018 07:18:01 pm)

Re: Select Multiple Level 2 dimensions for report?

Not that I know of.

An other option which may work is to create a new location in Items & Inventory (A location does not have to be tangible), then you can use the reports in Items & Inventory ie. if Dim 1 is a location, why not create a real location. Use a dimension as well to get the financials, and sales etc from the inventory

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/