I have a crosstab that is summarized the way the client wants with one exception. They want a subtotal by one of the groupings from an inner grouping. Below is an example. They have the Product Brand, Product Number and Unit of Measure in the crosstab summarized as they wanted. Now, they want to subtotal the Unit of Measure for the Product Brand. I have put a prototype I did in Excel below. I added the Total 25 kg and Total MT manually. I have highlighted where the totals are coming from.
My question, is this even possible in a crosstab report? I have tried to find something in the forum but no luck so far.