2 Values for 1 field name

[#1]

Hi Guys,

I have QV Doc thats loaded from Excel Spreadsheets,

Each Spreadsheet belongs to one of 4 teams , 'A','B','C' or 'D'.

On the load I have a statement that simply reads

'A' as Team

So on the QV doc there is a list box that we can click on and see data from that particular team

NOW, I have a 5th spreadsheet that belongs to Team A and B , the data on this spreadsheet is not split between teams, that is fine. Say for example [Number of transactions] is equal to 781 on this spreadsheet if I click on either Team A OR Team B I wish for the data to display 781.

I tried

'A','B' as Team result was only assigned to A

'A' &'B' as Team result was created new Team AB

I had thought about loading sheet twice , calling first load A and the other B then in the charts dividing by 2 ?

Anyone got any suggestions please ?

Thanks

Anne

[swuehl]

Hi Anne,

I think your last idea may be problematic, because you don't want to device all data by 2, only the shared one, do you? And then, how do you decide which data was originally shared after loading data twice?

No, maybe I would use a linkage table.

Load spreadsheets with label like sheet1, sheet2, sheet3 and then have table

with

Team, label

A , sheet1

B, sheet2

...

A, sheet5

B, sheet5

Maybe like this?

Stefan

Nachricht geändert durch swuehl

Nachricht geändert durch swuehl