Dear Members,
i have two questions. May I ask you please?
In webi Report (4.x) there are two queries.
- Query1 has dimensions as Country, City, Product Line and Product Color
- Query2 has dimensions Produkt Line, Product Color, Sales Person and a measure Sales Rev.
I have two merged dimensions:
Prod_Line (Query1.Prod Line and Query2.Prod Line)
Prod_Color (Query1.Prod Color and Query2.Prod Color)
Question 1:
How can I Summarize Query2.Sales Rev in a table on Query1.Country and Query1.City?
Question 2:
How can I make a cross tab with Lines of Query1.Country, with Columns of Query2.Sales Person and Sum(Query2.Sales Revenue) in the cells?
Thank You very much in Advance!
Best Regards
dve
dve (BOB member since 2006-06-14)