Row count in group header

[Artimidor]

Is it possible to have a row count in a group header? If so, how would one put it out?

For example, if the DataSource consist of something like this:

ProductId = 1, ReceiptId = 1
ProductId = 1, ReceiptId = 1
ProductId = 1, ReceiptId = 1
ProductId = 1, ReceiptId = 3
ProductId = 1, ReceiptId = 3
ProductId = 1, ReceiptId = 5

And there's a grouping by ReceiptId the detail would result in only three rows

ProductId = 1, ReceiptId = 1, Count 3
ProductId = 1, ReceiptId = 3, Count 2
ProductId = 1, ReceiptId = 5, Count 1

What I'd like to do is to add another grouping on top of this one with condition ProductId, and put out a count there which indicates that Product 1 has 3 receipts (grouped rows) in the grouping below. Is this possible?

Thanks in advance!

[Lech Kulikowski]

Hello,

You can use the grouping and Count(GroupBand, Column) function, or use the DataTransformation source for grouping and count calculation.

Thank you.