Group by with more than one column
Hi
I have a requirement where the output should be like this.
Workarea | Logname | logdate | contract no | Mode payment | Count | Amount |
---|---|---|---|---|---|---|
ACQ | MTC00085 | 29/09/2015 | 1000162258 | CN | 2 | 100.000 |
MTC00085 | 29/09/2015 | 941856 | WV | 1 | 150.000 | |
AD1 | MTC00099 | 29/09/2015 | 1000053103 | CN | 1 | 230.000 |
MTC00099 | 29/09/2015 | 1000241193 | WV | 1 | 150.000 |
here the 'count' is the no of transaction group by contract no then mode of payment.
I am using bip desktop where if I use the table wizard I am unable to to repeat the log name a log date .
And if I try with direct code like
<?for-each-group:Payments;./CBiO2AccountSequenceNumber?> and
count=<?count(current-group()/PaymentMethod)?>
I can group by the data only with any one of the element not more than that.