on 01-07-2015 7:24 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.