|
| I am trying to make an pivot table in Visual CE.
Simplified my dataset looks like this
Location Item Amount
A x 1
A y 3
A z 2
B x 3
B y 1
C x 2
I have made a selection form and ticked Location A and B and now I want an output as follows:
Location/Item x y z
A 1 3 2
B 3 1 0
----- ------------
total 4 4 2
Is this possible to do? | |
|
Seconds to generate: 0.109 - Cached queries : 58 - Executed queries : 9
| | |
|