Hello,
I would like to build a report which display, let's say, a list of products with only 2 information:
+ Product Name
+ Price
As there are only 2 information, I want to use multi-column in the page, so when it comes to the end of the page, it restarts to the begining, on a second column this is to save space in the sheet).
I used the out of the box "multi column layout", and set the number of column to 2 (catually it's 4, but it will be easier to explain).
Result is:
PRODUCT NAME.....PRICE |
PRODUCT 1..............10.00 | PRODUCT 5................30.00
PRODUCT 2..............10.00 | PRODUCT 6................40.00
PRODUCT 3..............50.00 | PRODUCT 7................20.00
PRODUCT 4..............40.00 | PRODUCT 8................80.00
Actually I would like a subtotal at the end of each column, and to report the total of the previous column on top of the next one.
I would like this:
PRODUCT NAME.....PRICE | PRODUCT NAME........PRICE
..........................................| Report:......................110.00
PRODUCT 1..............10.00 | PRODUCT 5................30.00
PRODUCT 2..............10.00 | PRODUCT 6................40.00
PRODUCT 3..............50.00 | PRODUCT 7................20.00
PRODUCT 4..............40.00 | PRODUCT 8................80.00
________________________|___________________________
...............................110.00 |.................................280.00
Do you think there is an out of the box functionnality to implement this sub total on the top and on the bottom?
thanks you very much for your help
Ahmed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.