ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Grouping a range in pivot without standard to from (https://www.excelbanter.com/excel-worksheet-functions/119140-grouping-range-pivot-without-standard.html)

mg

Grouping a range in pivot without standard to from
 
On the pivot table, I want to gropu a range.I do see an option of grouping it
is based on some range but can define only one "By". for example give me
range for 1-100 and split it in "By"- 10, this means, the range will be 1-10
, 10-20 etc...

ShaneDevenshire

Grouping a range in pivot without standard to from
 
Yes, but what do you want to do? In other words what is the question?

--
Thanks,
Shane Devenshire


"MG" wrote:

On the pivot table, I want to gropu a range.I do see an option of grouping it
is based on some range but can define only one "By". for example give me
range for 1-100 and split it in "By"- 10, this means, the range will be 1-10
, 10-20 etc...



All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com