Skip to Content
avatar image
Former Member

Need to add a whole column without showing the values

Hi

I have to make a summary page, where I have to sum a set of column and only display its sum. I don't want the column and its value to be displayed.

Eg

Colum1 Column2

1 20

2 40

3 50

Sum 50+40+20=110

SO in this I want to Display In a Page

Sum 110

Can any one plz advice ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 16, 2017 at 07:03 PM

    Hi Amit ,

    Is there any dimension available in the report layout or not ?

    Then u can used directly variable or function = Column1+Column2+Column3

    The above will give you the total values.

    Pls let me know if you need any help.

    Regards,

    Anish

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2017 at 05:26 PM

    What version are you using?

    We have new types of cells called "References" that are much like the Excel $A1 type of references. What you can do is have a "Details" tab that shows the full date and summarized the data you need to display in the "Summary" tab. Then you can reference the cells from the Details tab and show them on the Summary tab. This is a great use case for references as these won't need to be calculated to be displayed so performance is much better than re-calculating the values in a formula or hidden table.

    This section of the Webi User Guide talks about Reference Cells:

    https://help.sap.com/viewer/08732ee9b513420dbc9cef024a910d6e/4.2.4/en-US/3158e0330e8e46db8c498331cfd63aad.html

    Thanks!

    JB

    Add comment
    10|10000 characters needed characters exceeded