I have a conundrum and I've tried searching in the community for a solution and I cannot find the answer I'm looking for. Basically what I have is a list of jobs that have CUSIP totals under each job in a CSV file. I need for Alteryx to generate a report that will show the cusip level detail and totals for each CUSIP in a job and show a summarized total of each job with a calculation preformed on the summary total.
So far, this is what I have.
The top line at the split showing the CUSIP level detail and the bottom of the split showing the summary and calculation. I need to know how to marry the two and condense it into a report. Any help would be much appreciated!
@Amol_Telore - I have attached what you were unable to expand. Basically we want it to look as close to this as possible and just add a calculation to the Total Counts line for each grouping. Make sense?
@Amol_Telore - So I have two more questions. I have added two calculations to the end of the report. They both work but the last calculation "Due Date" shows up in a merged cell instead of it's own cell. Is there any way to fix this? I've tried and I can't figure it out for the life of me.
Also, I have tried making the report sort first by "Requestor" and it doesn't do it. It should be as follows, all ascending: Requestor, Reference #, Event ID, Job ID.