OBI : Consolidate duplicate values in a single cell
I have a difficulty to build my report in order to be clear.
The goal of my report is to have The number of submission by requisition first of all and then, on this number, the number of submission of each source.
So, I created a first column "Count submission by requisition" between the job req Title column and the Source Column.
My issue is to have several line with the same value just because there several line after this column.
For example, in my screenshot, I can see 5 submissions on the Job req, we have 3 duplicate lines because theses submissions have 3 different sources.