Pivot Table

[#1]

Good day,

I have table as a below:

Capaicty	Premium
5	2
10	4
8	6
7	8
12	5
4	7
5	9
9	11
8	13
15	15
12	17

I need to crate table in qlikview like this:

Capaicty	Premium
1 -  5	18
6 -  10	42
11 - 30	37

In excel I can use sumif to create table. Here I could not create. Please, help me

Thanks in advance

[#2]

You have buckets - I would suggest using the intervalmatch function - the help section is particularly good on this subject

[#3]

try to use class(Capacity,5) as dimension

sum(Premium) as expression

[#4]

Thanks very much for help. I am new in QlikView that is why I need will. I will write here my questions:)

[#5]

Does it work as you need?

[#6 · Accepted solution]

Yes wonderful. This function divides equal interval. I Now I try ti find unequal intervals

[#7]

Ok

So, you should mark some answer as correct to indicate that your problem is solved

regards

Darek

[#8]

I laughed when i spotted the correct answer Darek ^^^^

[senpradip007]

PFA. Hope it helps you.

[#10]