Pivot table with range dimension

[#1]

Hi Dear comunity

I need made a Pivot table with a range dimension. This is the original datatable

Age	Class	SubClass	Value
10	A	A1	100
20	A	A2	200
30	C	C2	300
60	D	D1	400
90	F	F2	500

The desired pivot table is:

Range (Age)	Value (Sum (Value))
From 0 to 15	100
From 16 to 30	500
Up to 31	900

Thanks !!

[Nicole-Smith]

Check out this thread/answer:

http://community.qlik.com/message/213862#213862

[danielact]

Just use some nested if statements to set it up however you want.

If(Age<=15,'From 0 to 15',if(Age<=30,'From 16 to 30','Up to 31')) would work for your dimension. The expression would just be sum(value)