Fetching Count and Sum Information different Reports

Hi All

 

I have an audit module which has a list as dimension. The list contains multiple report names. The List is pivoted as rows and line items has 2 columns as Count and Total_amount. My need is to go to respective source module of the reports and fetch the total count of records in that report and sum(Total_amount) in that report.

 

Please help suggest a right approach for the same.

 

Thanks

Yash 

Best Answer

  • VIGNESH.M
    Answer ✓

    Hi Vardhan,

     

    I have created Reporting List as shown below(Assume there will be 2 reports)

    Photo1.png

     

    In 1st reporting Module, add 2 line items(Count, Report Name)

    Count Line Item is Number Format.

    Count = 1

    Reporting Name Line Item is "Report List" Format

    Report Name= Report 1

     

    In 2ndt reporting Module, add 2 line items(Count, Report Name)

    Count = 2

    Reporting Name = Report 2

    Please check the attached Pic below

    Photo1.png.jpg

     

    In your Final Report Module, 

    Count = Sum the Count in Report 1 by Report Name+Sum the Count in Report 2 by Report Name

    Amount = Sum the amount in Report 1 by Report Name+Sum the amount in Report 2 by Report Name

     

    Photo1.png.jpg

     

    You can follow the same method for any count of Report.

     

    ~Vignesh

Answers