I want to perform grouping on column which is in the secondary data source. The two sheets are joined by performing data blending.
How should go about?
As far as I know you can't... But you could use the CASE function in a calculated field :
CASE *** WHEN
That should do the trick.
Retrieving data ...