Pivot Table with Multiple Data Sets

[langlang98]

I am unsure if this can be done or not. I want a spreadsheet with pivot table functionality(drag and drop movement) for simple analysis for people without advance excel knowledge. I'm looking to do something similar to what is shown below if it is possible(data set on each side of the Row Fields part of the pivot table). The idea of this format is due to Hyperion system generated report formats we have. I want to be able to have the pivot table mock the look of our standard formating of reports if possible.
Thanks,
Jim

<TABLE style="WIDTH: 224pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=298 x:str><COLGROUP><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; WIDTH: 87pt; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl22 height=17 width=116>Data Set 1(Sales)</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; WIDTH: 60pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl22 width=80>Cust Listing</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl22 width=102>Data Set 2(Qty)</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 height=17 x:num>550</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23>Customer 1</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 x:num>3300</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 height=17 x:num>38</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23>Customer 2</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 x:num>228</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 height=17 x:num>173</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23>Customer 3</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 x:num>1038</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 height=17 x:num>650</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23>Customer 4</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 x:num>3900</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 height=17 x:num>386</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23>Customer 5</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 x:num>2316</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 height=17 x:num>127</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23>Customer 6</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 x:num>762</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 height=17 x:num>77</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23>Customer 7</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 x:num>462</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 height=17 x:num>122</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23>Customer 8</TD><TD style="BORDER-BOTTOM: #e1e0d2; BORDER-LEFT: #e1e0d2; BACKGROUND-COLOR: transparent; BORDER-TOP: #e1e0d2; BORDER-RIGHT: #e1e0d2" class=xl23 x:num>732</TD></TR></TBODY></TABLE>