Pivot Table Columns

[#1]

Hi,

Is it possible to have two dimensions in single column? Say, Customers and Suppliers data being in same column.

[#2]

Sure, create a calculated dimension:

Customers & ' ' & Suppliers

[#3]

Thanks Miller.

By i would like to see them in rows and not by concatenating

Here is my explanation.

Customer Table

C1 C2 C3 C4 C5

Supplier Table

S1 S2 S3 S4 S5

I would make selection in customer table as C1,C2 and Supplier table as S1

My result table should be

Client Table

C1 C2 S1

[#4]

Then you would need to Concatenate the table (Union in SQL).

LOAD CustomerID As ClientID FROM Customer;
CONCATENATE LOAD SupplierID As ClientId FROM Supplier;

For Concatentate/Union, the table must have the same fields. If they don't you need to normalize them so they do.