Choose which Column to use

[dhborchardt]

I have an application that looks at different service areas indicated by zip codes. I can click on P and view only the zip codes that are in the primary service area, S and get secondary etc. I now need to be able to look at a second hospital which has different primary/secondary service areas. If I need to analyse Hospital 1, I will use the first column or (Hospital 1) to determine primary, secondary etc.. If I need to analyse hospital 2 I will use the second column or (Hospital 2). The application has four tabs and I hate to just recreate all four tabs. Is there a way to use a toggle button to select the column that gets used or is there some way I am not thinking of. I have included a very simplified example of the data below.

[MarcoWedel · Accepted solution]

Hi Dale,

you could try a crosstable load of your data.

This should give multiple possibilities to display and select your data as descibed:

table1:
CrossTable(Hospital ,ServiceArea, 1)
LOAD [Zip Code], Hospital1, Hospital2
INLINE [
    Hospital1, Hospital2, Zip Code
    P, N, 57834
    S, S, 57921
    P, S, 57333
    N, P, 57612
    S, S, 57002
];

hope this helps

regards

Marco

[dhborchardt]

Thank you. That did the job.