How do I create ONE summary report pulling from about 12 differentfields, with 5 different categories in each field, that are all on the same record?
I have a table named [Customer References] and there are 12 fields on the record that I need to summarize in one report that represent (type of reference asset). There is one field for case study, video, press release, ect.
Each field has an asset pipeline status; confirmed, complete, published, ect.
What I need to do is create a summary report that brings in all 12 fields from the Customer Reference record with count of the categories under each field.
The ideal report would have the (type of reference asset) as the column header and the rows would be the categories. And there would be a totals row at the bottom with counts of the categories in each Colum. But I can only have 6 crosstabs with this report and I need all 12 assets. Is there another way to build a summary table that has more than 6 cross tabs?