Afternoon campers, I have a head scratcher.....
This union query is a bit strange:SELECT [Full Sales History CY-0 AEM].Month, "AEM" as Region, "CY-0" as Period, [Full Sales History CY-0 AEM].SalesOrg, [Full Sales History CY-0 AEM].Material, [Full Sales History CY-0 AEM].[NS(F)], [Full Sales...