Grouping in Pivot table

[#1]

Hello,

Is there any way for grouping "unit of price" in a pivot table .(Example)

with Scale in 10000 unit.

unit of price :

0 to 10000

10001 to 20000

20001 to 30000

30001 to 40000

.....

.....    to 13395000

[Anonymous]

Saeed

Try adding a Calculated Dimension of :

     =round(DastyarSale_Data.Fe, 10000)

You probably want to sort by it as well.

Best Regards,     Bill

[#3]

YEs.

try to create in lo ad script a new dimension as:

....

load

unitprice,

if(unitprice>0 and unitprice<10000, 'group1',

      if(unitprice>10001 and unitprice<20000, 'group2',

              if(unitprice>20001 and unitprice<30000, 'group3'))) as Grouping,

....

So Grouping is a dimension for use in presentation.

REgards

MArio

[swuehl · Accepted solution]

You can use a calculated dimension with the class() function (or create an additional field in your load script using the same function).

[#5]

Thanks Friends.