Sum of revenue(on different reports) is different for the same list of items | Community
Skip to main content
cunnyong_goh
cunnyong_goh
New Participant
October 16, 2015
Solved

Sum of revenue(on different reports) is different for the same list of items

  • October 16, 2015
  • 4 replies
  • 2664 views

Hi,

 It seems that after breaking down and filtering for a keyword, the sum function of reports either did not add up the figure or it used the figure before filtering. 

1st way: Campaigns>Tracking Code>Campaigns Names (then filter for X)
2nd way(clicking the plus sign to break down-classification hierarchy): Campaigns>Tracking Code>Channel Names> Channel of X  (then filter for X)
3rd way(clicking the chart sign to break down): Campaigns>Tracking Code>Channel Names> Channel of X (then filter for X)

Among the above 3 ways, only the first one gets me to the correct sum. The sum on the second report shows a Zero while the sum on the third report shows a total for all the items for Channel of X. I believe that this happened because there was something wrong with the sum/total function(at the bottom of reports) of Omniture SiteCatalyst. 

Thanks.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Gigazelle

    This KB article will have everything you're looking for:

    http://microsite.omniture.com/t2/help/en_US/home/index.html#kb-sum-line-items-different-from-total

    I can assure you that the sum/total functions at the bottom of each report are working as intended. Thanks!

    ---
    If this answer was helpful, mark it with a 'heart'. If it answered your question, mark it correct.

    4 replies

    A
    Anonymous
    June 29, 2016

    My report has a total that is greater than the sum of the line items.  The reasons for this in the article you referenced are not applicable to my report.  It does not make sense to me why the total number of unique visitors would be greater since they should be falling into the bookmarked/typed category as a catch all.   I have uploaded the report here.  Can you please take a look and let me know what you think may be the issue.

    Gigazelle
    GigazelleAccepted solution
    Employee
    October 16, 2015

    This KB article will have everything you're looking for:

    http://microsite.omniture.com/t2/help/en_US/home/index.html#kb-sum-line-items-different-from-total

    I can assure you that the sum/total functions at the bottom of each report are working as intended. Thanks!

    ---
    If this answer was helpful, mark it with a 'heart'. If it answered your question, mark it correct.

    cunnyong_goh
    cunnyong_gohAuthor
    New Participant
    October 16, 2015

    ok. you might be right but how could the sum be zero in the case 2? There has to be a number for the sum when each individual item has a value. What do you think?

    2nd way(clicking the plus sign to break down-classification hierarchy): Campaigns>Tracking Code>Channel Names> Channel of X  (then filter for X)

    Gigazelle
    Gigazelle
    Employee
    October 16, 2015

    It would be difficult to provide an explanation to a report that I cannot see; if you're looking for exact reasons that would probably warrant creating an incident.

    However, if I was to speculate the reason, I anticipate it being because the metric you were using had data, and when you switched to a correlation, moved to page views without data.

    Terms & ConditionsAccessibility statement

    Loading footer...