FrontAccounting forum — Select Multiple Level 2 dimensions for report?

Re: Select Multiple Level 2 dimensions for report?

null@example.com (poncho1234) — Thu, 11 Jan 2018 19:15:57 +0000

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?

null@example.com (Squirrel) — Thu, 11 Jan 2018 16:18:49 +0000

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

null@example.com (apmuthu) — Wed, 10 Jan 2018 23:06:18 +0000

Only that Dimension will be filtered.

Re: Select Multiple Level 2 dimensions for report?

null@example.com (poncho1234) — Tue, 09 Jan 2018 21:42:40 +0000

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

Select Multiple Level 2 dimensions for report?

null@example.com (Squirrel) — Tue, 09 Jan 2018 20:43:29 +0000

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?