Dear experts,
I've got problems with building the following report
Number of Brands__________Number of assigned Materials
1#-____________________________________1500000
2##_____________________________________750000
3_______________________________________500000
4________________________________________30000
Total___________________________________2780000
Table: Materials assigned to a particular number of brands
'#' Material is only assigned to 1 brand for example to ABC.
'##' Material is assigned to 2 different brands e.g. ABC and XYZ.
with created DSOs (in an InfoSet):
1. Brand Franchise Code Assignment with following char key fields
___Franchise Code ID
___Brand
2. Material Franchise Assignment with following char key fields
___0Material
___0Soursystem
___Franchise Code ID
In the InfoSet, Franchise Code ID are the linked (join) fields.
Do you have any suggestion for the setup of the query?
Thanks for your help in advance!