Hi Group,
My tables created using axis specification are not being sorted by
columns. In the axis specification i have used multiple variables to
create a summary tables. The variables being used are categorical.
The syntax i used is..
Tabledoc.tables.AddNew("Table103","axis({base() [Ishidden =
true],q3a 'Iced tea in bottles or cans'expression('q3_1 =
{_1_Dunkin_rsquo_Donuts_carries_this_beverage }')} ) as axis1_
+ axis({base () [Ishidden = true], q3b 'Freshly brewed iced
tea'expression('Q3_2 =
{_1_Dunkin_rsquo_Donuts_carries_this_beverage}')}) as axis2_
+ axis({base () [Ishidden = true], q3c 'Coolatta'
expression('Q3_3 =
{_1_Dunkin_rsquo_Donuts_carries_this_beverage}')}) as axis3_
+ axis({base () [Ishidden = true], q3d 'Smoothies'
expression('Q3_4 =
{_1_Dunkin_rsquo_Donuts_carries_this_beverage}')}) as axis4_
+ axis({base () [Ishidden = true], q3e 'Hot tea'
expression('Q3_5 =
{_1_Dunkin_rsquo_Donuts_carries_this_beverage}')}) as axis5 *
Gender", "Summary Table")
Tabledoc.table103.SortColumn = "Gender{base}"
Please let me know how this type of tables can be sorted by
descending.
Thanks,
Zabi