How to tile

[Hamder83]

Hi 


Im trying to add groups to a dataset using tile, but I cant get it all right.

I have a table with data something like this:

InvoiceNumberSales	FileName	Value	Tile_Num	Tile_SequenceNum
SI1000021774	A	123456	1	1
SI1000021774	B	123456	1	2
SI1000021999	21999	123456	2	1
SI1000011111	11111	123456	3	1
SI1000011123	11123	123456	4	1

I want to check if I have the same invoicenumber in more than 1 file.
So within each invoicenumber filename it should count from one.

So 
SI1000021774 - FileName: A should be 1

SI1000021774 - FileName: B should be 2

Among others, I tried this, but I dont get the right grouping:

Do really need to summarize on invoicenumber and filename and then tile on top of that?

Kind regards

[Qiu · Accepted solution]

@Hamder83 If we want to check iif there is same invoicenumber in more than 1 file, then we should group by nvoicenumber and check Unique value for File name.

Consequently, the result is not exactly as you want.

With one more Multi-row tool. I think we can do it though.

[Hamder83]

Argh, that is basicly the one solution I have not tried haha ... thank you very much @Qiu :-)

[Qiu]

@Hamder83 
Glad to help.