report calculation - how to

[#1]

Hi everyone,

this is my very first post.

I would like to add a column (metric)

It will get the value (page views) of the 4th row and sum it to each row from the report.

New column beside page views :

37

34

13

6

Is there a way to do that?

Obviously, it s a very simple calculation for a start.

thanks

[#2 · Accepted solution]

Hi,

I am though unclear of the business requirement over here as usually, adding a metric's data to line items belonging to other line item is not a best practice. Assuming it as an implementation bug , here are couple of workarounds:

• Create a calculated metric : Page Views + "Hard code metric data in line item 4" and add in the report - Create Calculated Metrics
• Login to report builder, replicate the same report in excel and apply excel formulas for a final report view (dynamic approach) - Invoke Report Builder Functionality from Microsoft Excel Functions

[#3]

Thank you all,

I will review your comments and read the different links.

hopefully, I will understand how to do it and will get back to you.

[#4]

I would suggest you to use numeric 2 classification. Numeric 2 Classifications

Examples: Examples

The post above suggestions are also valid but you might want to explore numeric 2 classification as it is powerful when used correctly to calculated new metrics based on existing metrics values.