Fetching Count and Sum Information different Reports

Highlighted
Occasional Contributor

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 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Fetching Count and Sum Information different Reports

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

Highlighted
Occasional Contributor

Re: Fetching Count and Sum Information different Reports

Thanks Vignesh for the detailed reply !