Data Detail with Summary and calculation based on Summary.

[Joseph_Mediant]

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!

Best,

Joseph Simonowich

Mediant Communications, Inc.

[Joseph_Mediant]

Hi @Amol_Telore - Any luck on this yet?