Grouped Dimension: Employee Role

[#1]

Hello,

The data table is a series of invoices as rows and has 4 columns identifying who is the Account Manager, Sales Rep, Tech Rep and Extra.

When I load the data I am presented with these 4 Dimensions but i wish to create one Dimension: "Employee", when the name is selected it will show all the rows where this employee is an Account Manager, Sales Rep, Tech Rep and/or Extra.

Let me know your thoughts,

Jarl.

[stigchel]

do a crosstable load of the 4 dimensions, something like

crosstable ( Type, Employee, 1)

I'd,

AccountManager as Account Manager,

DalesRep as Sales Rep,

..

See help for crosstable load

[pokassov · Accepted solution]

Hi!

You can create another table from your data table:

Employees:

load

     IDInvoice,

     [Account Manager]          as Employee,

     'Account Manager'          as Position

Resident

     DataTable;

concatenate (Employees)

load

     IDInvoice,

     [Sales Rep]               as Employee,

     'Sales Rep'               as Position

Resident

     DataTable;

...

delete fields [Account Manager], [Sales Rep] from DataTable;

Sergey

[#4]

Thank Sergey and Piet.