Issue with pivot hypercube in a mashup

[#1]

I'm trying to create a pivot hypercube with two dimensions in a mashup, but I can't get it to use the second dimension, it just sums by the first one.

I created the hypercube using the Hypercube builder.

Am I doing something wrong or is this a limitation of Qlik Sense?

Input data -

Option	Duration	Value
A	1	0.1
A	2	1.5
A	3	2
B	2	1.25
B	3	2.1
C	2	1.6

What I want -

Option	1	2	3
A	0.1	1.5	2
B		1.25	2.1
C		1.6

What I get -

Option	Sum(Value)
A	3.6
B	3.35
C	1.6

[#2 · Accepted solution]

I needed to add "qNoOfLeftDims": 1