Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to create and present cross tabulation?
I created an add-in for cross tabulation. It uses pivot table feature.
Suppose I have a list Question1 Question2 Question3 m 1 Joe f 2 Mike m 4 Ellen m 3 Mike .. . . .. . . .. . . Q1 is set to the column field. Q2 and Q3 is crossed against Q1, etc. Q1 Q2 Q1 Q3 .... A one way to label pivottables is to change the data in the list Question1.Your Sex Question2.Your weight Question3.... male 1.less than 40kg .... But this method costs time and disk space for a large data. Also pivottables generated by this method is not acceptable as presentation for most users. Alternative way is to use getpivotdata function. Create pivottables in a sheet and create another worksheet for presentation using getpivotdata, such that a user can label rowfields and rowfields' items, add notes and change formats, etc for a report. In this case, I'd have to provide a user cell references for corresponding pivottable cell position,rowfield name, rowfield item name, columnfield name, columnfield item name, etc where a user want. Also, getpivotdata function is not backward compatible from 2002 to 2000, I suppose. What do you think the best way to create a cross tabulation data and to present the result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a new row when data present in a column | Excel Discussion (Misc queries) | |||
how do i set up cross tabulation in excel file | Setting up and Configuration of Excel | |||
contingency table or cross tabulation | Excel Discussion (Misc queries) | |||
contingency table or cross tabulation | Excel Discussion (Misc queries) | |||
Create a database of past and present customers | Excel Discussion (Misc queries) |