software

I'm trying to create a pivot with two columns. I want the first column to
lists deals corresponding to their revenue type such as support, license etc.
, furthermore I want the same information categorized to the right of this
column but this time depending on the specific quarter in which we expect to
close the deal. However when I try this in Pivot I first get quot;License - Q1,
Q2, Q3 amp; Support - Q1, Q2...quot; and so on. Is there a way that enables me to
present it like quot;License, Support...quot; and its corresponding figures and the
similar figures but as quot;Q1, Q2...quot; and so on?

Many thanks in advance / Johan

If you put Quarter in the column area, you'll get a column for each
quarter's data.

Johan wrote:
gt; I'm trying to create a pivot with two columns. I want the first column to
gt; lists deals corresponding to their revenue type such as support, license etc.
gt; , furthermore I want the same information categorized to the right of this
gt; column but this time depending on the specific quarter in which we expect to
gt; close the deal. However when I try this in Pivot I first get quot;License - Q1,
gt; Q2, Q3 amp; Support - Q1, Q2...quot; and so on. Is there a way that enables me to
gt; present it like quot;License, Support...quot; and its corresponding figures and the
gt; similar figures but as quot;Q1, Q2...quot; and so on?
gt;
gt; Many thanks in advance / Johan--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html