| Display Values in PIVOT TABLE [message #352149] |
Mon, 06 October 2008 05:46  |
deepz
Messages: 2
Registered: October 2008
|
Junior Member |
|
|
Hi All,
I want to build a cross tab report. My XML is the following
<row>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>MHO</SUBLOCATION>
<GL>ASSET</GL>
<AMOUNT>700</AMOUNT>
</r>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>MHO</SUBLOCATION>
<GL>LIABILITY</GL>
<AMOUNT>900</AMOUNT>
</r>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>ADH</SUBLOCATION>
<GL>LIABILITY</GL>
<AMOUNT>300</AMOUNT>
</r>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>ADH</SUBLOCATION>
<GL>ASSET</GL>
<AMOUNT>200</AMOUNT>
</r>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>FLX</SUBLOCATION>
<GL>ASSET</GL>
<AMOUNT>500</AMOUNT>
</r>
<r>
<LOCATION>CHN</LOCATION>
<SUBLOCATION>ADH</SUBLOCATION>
<GL>LIABILITY</GL>
<AMOUNT>200</AMOUNT>
</r>
<r>
<LOCATION>CHN</LOCATION>
<SUBLOCATION>FLX</SUBLOCATION>
<GL>ASSET</GL>
<AMOUNT>500</AMOUNT>
</r>
</row>
My RTF file is attached here , I am not getting values in the proper order since some values are null in the pivot table,
please check the attached rtf file for more details
please help me
my code is below
<?for-each-group:r;./LOCATION?><?sort:LOCATION;'ascending';data-type='text'?>
<?LOCATION?>
<?horizontal-break-table:1?>
<?for-each-group@column:current-group();GL?>
<?GL?>
<?end for-each-group?>
<?for-each-group:current-group();./SUBLOCATION?>
<?SUBLOCATION?>
<?for-each-group@cell:current-group();GL?>
<?sum(AMOUNT)?>
<?end for-each-group?>
<?end for-each-group?>
<?for-each-group@column:current-group();GL?>
<?sum(current-group()/AMOUNT)?>
<?end for-each-group?>
<?end for-each-group?>
thanks in advance
Deepz
[Updated on: Mon, 06 October 2008 05:50] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
