FrontAccounting forum — Select Multiple Level 2 dimensions for report?

Re: Select Multiple Level 2 dimensions for report?

2018-01-11T19:15:57Z

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

Re: Select Multiple Level 2 dimensions for report?

2018-01-11T16:18:49Z

@ 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.

Re: Select Multiple Level 2 dimensions for report?

2018-01-10T23:06:18Z

Only that Dimension will be filtered.

Re: Select Multiple Level 2 dimensions for report?

2018-01-09T21:42:40Z

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

Select Multiple Level 2 dimensions for report?

2018-01-09T20:43:29Z

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?