AnsweredAssumed Answered

Sub Summary Grouped By Multiple Finds

Question asked by laguna92651 on Oct 3, 2018
Latest reply on Oct 7, 2018 by philmodjunk

Is it possible to create a sub summary report that will show records multiple times, depending on entries in four different fields? Four different names, Lauren, Kayle, Jennifer or Joe, are entered into four columns Short List, CV Sent, Interview and Under Offer. These four people are responsible for the four different parts of the hiring process.

Before Find.jpg

I would like to create a report that would have four sections grouped by each of the four people. In this case the grouping shows all of the records where Kayle is entered into any of the four fields Short List, CV Sent, Interview and Under Offer.

After Find.jpg

 

Short List, CV Sent, Interview and Under Offer.

Outcomes