Solved Thanks All ! -- Analysing Data

[Girish]

I have 35 columns of data & around 10000 rows.
few of the columns are
ID Name Sex Age Country Region Date Sales ...

I would like to generate reports that will tell me e.g. Total number of sales persons in the organization is .. & average age is .. & .. males .. females & average sales are ..

same for a particular country or region etc....

same for a particular date/date range ...

Think I am demanding too much, but is there any way for this ?

Thanks in advance.
Girish
This message was edited by Girish on 2002-05-09 11:00

 

[Girish]

>Why don't you make 'country' a PAGE field?

Then I won't be able to select more than one country ...
This message was edited by Girish on 2002-05-08 14:31

 

[Mark W.]

Perhaps I misunderstood your question. When you say "filter on country=USA" do you mean exclude from the PivotTable? Do you have a finite set of countries and are they all represented in your data set?
This message was edited by Mark W. on 2002-05-08 14:36

 

[Girish]

On 2002-05-08 14:35, Mark W. wrote:
Perhaps I misunderstood your question. When you say "filter on country=USA" do you mean exclude from the PivotTable? Do you have a finite set of countries and are they all represented in your data set?

"filter on country=USA" means only show records for USA. I have 10 countries to select from(I can check the countries to see other details in pivot table).
In short what I want is Country similar to be a page field, but I can select multiple countries & I don't get details of each country seperately (i.e. only total for selected countries)

 

[Mark W.]

"filter on country=USA" means only show records for USA. I have 10 countries to select from(I can check the countries to see other details in pivot table).
In short what I want is Country similar to be a page field, but I can select multiple countries & I don't get details of each country seperately (i.e. only total for selected countries)

Now you have me more confused. Are we discussing PivotTables or how to AutoFilter a list?

If we're discussing PivotTables consider this data set...

{"Country","Region","Value"
;"USA","East",10
;"USA","West",15
;"France","South",20
;"France","North",25
;"Germany","East",30
;"Germany","West",35}

...and a PivotTable with 'Country' and 'Region' in the ROW area and 'Sum of Value' in the DATA area.

Did you know that you can double-click on "France" to toggle between Hide and Show Detail?
This message was edited by Mark W. on 2002-05-08 15:03

 

[Girish]

In the data you provided forget France for a moment.
Now when I check the boxes for Germany & USA (in country drop-down), Excel should display me the total(USA+Germany) sales for east region & west region. I don't want countrywise region sales (seems weird right ?). But this is exactly what I want.

Thanks a lot Mark for your help.

Girish

 

[Mark W.]

On 2002-05-08 15:18, Girish wrote:
In the data you provided forget France for a moment.
Now when I check the boxes for Germany & USA (in country drop-down), Excel should display me the total(USA+Germany) sales for east region & west region. I don't want countrywise region sales (seems weird right ?). But this is exactly what I want.

Thanks a lot Mark for your help.

Girish

Ahh, this is known as Grouping...

1. Select USA and Germany items
2. Right-click and choose Group and Outline | Group... from the popup menu.
3. Click on the "Group1" label and overwrite it with "Germany & USA" or whatever makes you happy.
4. Drag the original 'Country' field button out of the PivotTable.