PLEASE HELP: How can I achieve the expected result as shown?

[tarunIMDG]

How to group the given sample data by Vintage and Collection-Vintage so that I can get the expected result as shown in column F.  (attached is the sample data)

[IraWatt]

Hey @tarunIMDG,

I think this captures your logic:

The multi row checks the collection vintage on the line above. If its the different then it increases the result if its the same the result stays the same. Hope that makes sense!

Ira

[grazitti_sapna]

Hi @tarunIMDG ,

This is something to what @IraWatt  did but I used smart tile instead.

Thanks!