Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
I don't understand the problem. That sounds like the standard behaviour of a default pivot table. See attached qvw.
Use Chart Type Pivot Table
I don't understand the problem. That sounds like the standard behaviour of a default pivot table. See attached qvw.
Yeah, it seems when I did partial sums, it worked. Thanks a lot!
go to the object properties,
Presentation tab=====>
select the Y diemention and check the Show Partial sums option
Click apply