P
polisci grad
Is it possible to display data, in a form, in a table-like time series
format, without aggregating values? The pivottable display offers potential,
but for some reason I cant just get it to display the actual value in the
data table.
My data is organized into a large, relatively flat, file with many foreign
key fields identifying the data. For instance, one record includes:
Generated ID, Value for Theme (1=safety, 2=trade, etc), Value for Industry
(1=road, 2=sea, etc.), Name of Variable (col_f_b = Fatal Collisions involving
buses), Value for Region (1=Canada), Year, and then finally the actual value
(63 collisions with buses).
I would like for users to select the variable they want, the years they
want, and have it displayed in a table-like format in a form, without
aggregating the values, which is all the Wizard will allow me to do...Any
help would be greatly appreciated.
Thanks!
format, without aggregating values? The pivottable display offers potential,
but for some reason I cant just get it to display the actual value in the
data table.
My data is organized into a large, relatively flat, file with many foreign
key fields identifying the data. For instance, one record includes:
Generated ID, Value for Theme (1=safety, 2=trade, etc), Value for Industry
(1=road, 2=sea, etc.), Name of Variable (col_f_b = Fatal Collisions involving
buses), Value for Region (1=Canada), Year, and then finally the actual value
(63 collisions with buses).
I would like for users to select the variable they want, the years they
want, and have it displayed in a table-like format in a form, without
aggregating the values, which is all the Wizard will allow me to do...Any
help would be greatly appreciated.
Thanks!