Report tables combining and counting like results

My results from a CE Report table is shown below:

I would like to combine same Cell Name entries into one row and be able to have a column that gives me total number of cells on the drawing. 

So, A3-20-20 shows at total of 5 on the drawings. I would want one entry:

A3-20-20    Q-SHLG       5

Thank for your input.

Roland

Parents Reply
  • Carl,

    Thanks for the links. It looks like Connect does not do a total count of cells on a single line per the first link:

    "lack aggregate functions, such as a total count capability"

    Looks like to do this we will need to export to Excel and correct the output to what is expected:

    Cellname             Total number of cells

    Unless someone else has an answer that works inside of Connect.

    Thank you,

    Roland Cyr

    CE Update 7 - Version 10.07.00.39

Children
No Data