Dimensions and Expression - creating a simple Table

[#1]

Dear QV commuity,

today i have a (i think) basic question.

Of yourse our management is used to work in XLS and there the tables are always the same like this

                    JAN     FEB     MAR     APR ...

Country1       sales

Country2       sales

etc...             sales

So basically QV works with Expressions and Dimensions - in this case Months and Countries are bot Dimensions and i have to CHOOSE if i want to show them horizontal or vertical - but as you can see i need to choose INDIVIDUALLY to have one dimension horizontal and the other vertical.

Is thsi possible? seems so simple but i could not find

Thanx for your help

Seb

[#2]

I do this all the time for sales reports. It's always a PIVOT table, and I make the vertical dimension the sales rep, and the horizontal dimension the month. The expression is then simply =sum(SalesAmount).

Note to QV: Please give us a keyboard shortcut to "pull" a dimension up to the horizontal. The "grab and drop" feature is very tempermental; I find I have to do it five or six times before I get it to work. (There's actually a table way below, but this lousy editor won't let me delete the intervening white space; you'll have to scroll down to see it)

Sales Rep	Close Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
EKES		$98,663	$41,347	$449,277	$116,679	$248,473	$252,084	$103,402	$335,078	$268,779	$423,682	$23,400	$0	######
JSIL		$27,000	$0	$43,100	$90,600	$8,140	$4,000	$3,500	$85,750	$180,965	$8,000	$0	$0	$451,055
MCRO		$2,820	$20,965	$30,360	$33,183	$15,319	$105,259	$26,602	$5,200	$116,282	$43,099	$19,890	$0	$418,979
PDEV		$73,170	$56,530	$29,991	$0	$0	$13,639	$11,412	$54,700	$78,617	$81,500	$0	$0	$399,559
RCAN		$14,340	$50,688	$20,052	$18,000	$8,620	$6,980	$1,500	$6,040	$146,412	$69,250	$32,000	$0	$373,882
SBAR		$137,742	$18,864	$19,139	$8,160	$30,720	$0	$105,227	$3,000	$6,430	$6,500	$0	$0