Here's a great question from a client which I thought was worth sharing in the Forum:

I need to be able to create a metric in Omniture that would be based on another metric as a % of Total. Here is an example

Let's say the data looks like this:

Month Site Page Views
Jan-2010 A 600
Jan-2010 B 400
Feb-2010 A 800
Feb-2010 B 200


I need a Page Views % metric which would be Page Views / SUM(Page Views). Then I would have something like this:

Month Site Page Views Page Views %
Jan-2010 A 600 30%
Jan-2010 B 400 20%
Feb-2010 A 800 40%
Feb-2010 B 200 10%


But if I decide to only show Jan-2010 (by using the sidebar filters) then I should have:

Month Site Page Views Page Views %
Jan-2010 A 600 60%
Jan-2010 B 400 40%

Does this make sense? Can you please let me know how I can achieve it with Omniscope?

I address the question in two parts:
1.) Use a Subset function to get to the % of total
2.) Filters and formulae are not connected, so it's not possible to achieve part III [of the question above] in Omniscope.

Is that about right? Any/all additional context is welcome.

James