You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom summary calculation for Analytics report

Received Response
34
Views
1
Comments
edited Nov 3, 2015 2:10PM in Reporting & Analytics for B2C Service 1 comment

Content

We have a unique report where we want to have custom summary calculation that is dependent on the summary information from other 2 columns.

For e.g. please see the data below. We want to calculate the summary percentage as sum(column2) /sum(column 1) and not the average of percentage for column 3.

Account Column 1 Column 2 Column 3
John Doe 5 3 60%
Smith 10 4 40%
Summary 15 7  

We tried quite a few standard options but still havent found any solution. Can anyone guide us further.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!