Pivot table grouping (URGENT!)

G

Guest

Hi All,

I have a pivot table which has currency amounts in the column and a count of
claims in the data area.

I have grouped by 100, starting at 0 running to 600.

The only thing I'm questioning is when it gets to 200 I think its including
any spend in the group 100-200 then again in the group 200-300. Is there
anyway I can get the grouping to run from 0-100, then 101-200, 201-300 etc?

Please advise
 
D

Debra Dalgleish

When you group by 100, the groups shouldn't overlap. If you start at 0,
it should automatically group by 0-99, 100-199, etc.
 

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

Similar Threads

Pivot table and value range 2
Calculated Item causes undue repitition in pivot table 2
Creating a pivot table which resembles a SQL 'group by' 2
Column Heading on each row in pivot table 1
Pivot Table Grouping 3
Consolidate Pivot table from multiple files 4
DCOUNT Help! 1
Simple Excel Question 6

Top