Pivot table help

[#1]

Hey guys,

I need help making a pivot table.

My data looks something like

X     Y    Sum(values)

----------------------------

A     1             2

A     2             2

A     3             1

A     4             2

A     5             2

B     8             1

B     9             1

C     10            2

D     11            2

E     12            2

How do I get a pivot table where it would look something like

X    Sum(values)

A(+)     8

B(+)     2
C(+)     2
D(+)     2
E(+)     2

and if u press the + button on the A, it would show

X        Sum(values)

----------------------------

A  

    1             2

    2             2

    3             1

    4             2

    5             2

or something similar of that fashion...

[#2]

Use Chart Type Pivot Table

[Gysbert_Wassenaar · Accepted solution]

I don't understand the problem. That sounds like the standard behaviour of a default pivot table. See attached qvw.

[#4]

Yeah, it seems when I did partial sums, it worked. Thanks a lot!

[qv_testing]

go to the object properties,

Presentation tab=====>

select the Y diemention and check the Show Partial sums option

Click apply