I am building a cube that will display financial performance metrics
for a given firm, and I also want to display the same metric for all
firms in the database next to the individual metric. For example, in
a simple cube with a fact table containing the metrics and two
dimensions, one for time/dates and the other for firm id's, I will
have the rows display period information. Say I have a metric for '%
of revenue generated by new customers'. The column for the individual
firm selected is displayed no problem, and next to it I would like the
overall percentage for all firms in the database:

FirmID: 19

Firm19 Everybody
Year 2003 15 12
Qtr 1 15 12
J 25 10
F 15 9
M 5 17


I am not sure where to begin.

Thanks.

Tom McCobb