how to reference the first row using multi row formula tool

[rick007]

Hi,

I have a problem wherein I need to find the difference of each product from the first product grouped by category. In other words, every row in a category is referencing the first row.

Thanks

[fmvizcaino · Accepted solution]

Hi @rick007 ,

I don't think it is possible to do with multi-row, but here is a suggestion using grouping samples + join.

Best,

Fernando Vizcaino

[grazitti_sapna · Accepted solution]

Hi @rick007,

Let me know if this is what you are looking for.

[rick007]

Super!!

And then I used multi field tool to get the difference.

Thanks for the help.