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.
![]()
Thank you,
ROD>
My question, is this even possible in a crosstab report? I have tried to find something in the forum but no luck so far.
Thank you,
ROD>
3 Answers, 1 is accepted
0
Rod
Top achievements
Rank 1
Rank 1
answered on 18 Sep 2014, 03:14 PM
My pasted in image did not come across. Attached below.
ROD>
ROD>
0
Hinata
Top achievements
Rank 1
Rank 1
answered on 23 Sep 2014, 10:28 AM
Hi Rob,
I don't think this is possible given the crosstab structure. The workaround is to create another crosstab, but group by the Unit of Measure first, and then by the Product Number. This will allow you to retrieve the Unit of Measure subtotals.
I don't think this is possible given the crosstab structure. The workaround is to create another crosstab, but group by the Unit of Measure first, and then by the Product Number. This will allow you to retrieve the Unit of Measure subtotals.
0
Rod
Top achievements
Rank 1
Rank 1
answered on 23 Sep 2014, 01:52 PM
Thank you. You confirmed what I thought.