Pivot and columns

J

Johan

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 "License - Q1,
Q2, Q3 & Support - Q1, Q2..." and so on. Is there a way that enables me to
present it like "License, Support..." and its corresponding figures and the
similar figures but as "Q1, Q2..." and so on?

Many thanks in advance / Johan
 
D

Debra Dalgleish

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top