Crosstab possible?

bmuskie

Hi,

My db contains:

product A, supplier A, price
product A, supplier B, price
product A, supplier C, price
product B, supplier A, price
product B, supplier X, price
product C, supplier D, price
product C, supplier E, price
product C, supplier F, price
product C, supplier G, price
etc....

Could I create a report like below?

Product A, supplier A's price, supplier B's price, supplier C's price
Product B, supplier A's price , supplier X's price, supplier
Product C, supplier D's price , supplier E's price, supplier F's price, supplier G's, price

Thanks!

mwilliams

Hi bmuskie,

This looks like the perfect situation for use of a crosstab. You'd just create a dataCube with price as the measure and product and supplier as the dimensions. Then, in the report design, you'd place a crosstab and drag the supplier over as the column dimension from the dataCube, the product over as the row dimension, and the price over in the measure area. This should do exactly what you've described. Let me know if you have questions.