Median on specific base in data

[SagarGite]

Hello,

I would like to have median in separate column, and the median value is depend upon specific base value. In attached file base value is column Brand Name

Please help me with workflow solution for interested output.

Thanks

[grossal · Accepted solution]

Hi @SagarGite,

here is a quick way to do this:

Output:

Workflow attached. Let me know what you think.

Best

Alex