Group metric

[lincon]

Dear All,

I need to generate the following kind of report.

Sale_Rep Sales Target | Total of order
SalePlan SaleACT |OrdPlan OrdACT
Sr 1 100 120 | 100 90
Sr 2 200 190 | 300 270

Attribute(Sale_Rep) and metrics(SalePlan,SaleACT,
OrdPlan,ordACT)come from the column of the same
fact table. I want to add a header to class the
sales and order. But I only can get the following kind
of report in Microstrategy :


Sale_Rep SalePlan SaleACT OrdPlan OrdACT
Sr 1 100 120 100 90
Sr 2 200 190 300 270

How can I get the report that I hope?

Thanks&All

Lincon

 

[User14]

You can achieve the same by using document. In the document you include the report in the table with the heading of Sales Target and Total Order.

Please forward your email id. I will send you the word file that will show you how the report will look in the document with the two headings.

User14

 

[lincon]

User14
Thank your responding!
I Email id is lincon_sh@hotmail.com

Thanks a lot£¡£¡