Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some table data. i want distinct and count group by values in column wise.
How to do this..
Refer the sample data (pls. ignore the yellow highlighted rows. because it is duplicated .)
The challenge of the task is, column "Status" is always dynamic. So the count automatically change based on the status.
Currently we have "APPROVED,PENDING,REJECT AND ON_HOLD" Status. It will be dynamic. it may increase/decrease the values. like Status may also include NOT APPLICABLE. APPLICABLE,etc.
based on that the count should appear.
consider "Ref No" by is group column.
So the Final output would be as below.
Pls. find Sample test data as Attached.
any update pls...
any update pls...