Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MultiColumn

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 (actually 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

Former Member
Not what you were looking for? View more on this topic or Ask a question