Additional Subtotals in Cross Tabs

4 posts, 0 answers
  1. Rod
    Rod avatar
    13 posts
    Member since:
    May 2010

    Posted 18 Sep 2014 Link to this post

    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>
  2. Rod
    Rod avatar
    13 posts
    Member since:
    May 2010

    Posted 18 Sep 2014 Link to this post

    My pasted in image did not come across. Attached below.

    ROD>
  3. Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 23 Sep 2014 in reply to Rod Link to this post

    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.
  4. Rod
    Rod avatar
    13 posts
    Member since:
    May 2010

    Posted 23 Sep 2014 in reply to Hinata Link to this post

    Thank you. You confirmed what I thought. 
Back to Top