Summary

Get horizontal total and vertical totals of Matrix Report in XML Publisher

Content

I need to print horizontal total and vertical totals. Could you please let me know how to print the report in the above format. My XML data is in below format; My output format is something like this;

<XXSLC_LAUND_DEL_DETL>

  <LIST_G_SHIP_DATE1>

    <G_SHIP_DATE1>

      <MONTH_DATE>01-MAR-17</MONTH_DATE>

      <ITEM_DESCRIPTION>Bath mat</ITEM_DESCRIPTION>

      <ITEM>LL0004</ITEM>

      <QTY>387</QTY>

    </G_SHIP_DATE1>

    <G_SHIP_DATE1>

      <MONTH_DATE>01-MAR-17</MONTH_DATE>

      <ITEM_DESCRIPTION>Bath robe</ITEM_DESCRIPTION>

      <ITEM>LL0006</ITEM>

      <QTY>37</QTY>

    </G_SHIP_DATE1>

    <G_SHIP_DATE1>

      <MONTH_DATE>01-MAR-17</MONTH_DATE>

      <ITEM_DESCRIPTION>Bath towel</ITEM_DESCRIPTION>

      <ITEM>LL0008</ITEM>

      <QTY>618</QTY>

    </G_SHIP_DATE1>

</LIST_G_SHIP_DATE1>

</XXSLC_LAUND_DEL_DETL>

Regards,

dcr