Skip to Content
avatar image
Former Member

Repeated values in rows and subtotals

Hello everyone,


In my table I have created a subtotal to sum some kind of records, but some records  are alone , so these records are being show at the row for it self and at the subtotal, I wonder if I can hide those lines (records) and then don't repeat the same value twice.


I have attached a pic of the issue

Many thanks

sap.PNG (5.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 07, 2015 at 10:13 PM

    SAlve Bruno,

    I think that you can try hiding the lines where the count of them is 1. In this way, only the break footer will be shown.

    ABra├žos,

    ROgerio

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 01:17 PM

    Hi Bruno,

    for totals , write formula =count([Product])>1;sum([Measure])

    apply auto height.It'll not be exactly like hiding ,but we are making measure as null in cases where count is 1.

    Add comment
    10|10000 characters needed characters exceeded