Ranges in pivot report

  • Thread starter Thread starter NetNewbie
  • Start date Start date
N

NetNewbie

Hi all,

I have a column called IncomeRange. I need to display the value in ranges
like 0 - 100, 101-200 etc., How can I convert a column in a pivot report to
display as ranges? Is this an option or do I need to do some kind of formulas
or macros?

Thanks for all help
 
Just wannted to explain a little more.

Hello,

My requirement is to create a pivot report in which a column called
indexrange is to be displayed as n number of intervals eg: 0-9, 10-19 etc.

The source of data for the pivot is a SQL Server query. I am not sure where
or how can I do it, so I am posting this in both groups.

Is it possible to take a value in a column and calculate and then return
multiple columns for multiple ranges?

example

baseCol values 0-9 10-20 21-30 31-40 etc
15 1
20 1
6 1
33 1
9 1
28 1

Thanks for any help and suggestions
 
Back
Top