@Darren_Murphy Looking at your example for Apples, it seems weird to me that Apples-Initial would have any results. It makes complete sense based on your query, but the use case just seems odd to me.
mmm yes, I hadn’t noticed that. And I can’t explain it… odd
But yes, I think we need some clarification of the goal.
Hi Guys, Sorry about the late reply.
I want all items with Status “Negotiated” to be grouped by “Opportunity Name”
The result I need is how many Opportunities Name groupings have status “Negotiated”
In My Table every row is an entry and every Row can have a same opportunity name or a different opportunity name. I want to group all the Rows having status “Negotiated” by checking Opportunity name.
hope this gives better clarity.
Thank you guys for responding.