function peek()

[omarlq20]

I need to perform the following pivot table design

ID	Product	Qty	Price
1	CD	20	10
2	DVD	15	15
3	Blu-ray	25	20

ID	Input	Output
1	5	10
2	10	10
3	10	15

ID	Product	Stock	Input		Total Input	Output		Total Output	Total
			Qty	Price		Qty	Price
1	CD	20	5	10	25	10	10	15	150
2	DVD	15	10	15	25	10	15	15	225
3	Blu-ray	25	10	20	35	15	20	15	300

[alexandros17]

Here is an example, hope it helps

[omarlq20]

I need titles appear the way you've placed, input as title and subtitle below as quantity and price.

[alexandros17]

It would be beautiful but it's not possible ... sorry

[SunilChauhan]

never say its not possible

see the attached file

hope this helps

[alexandros17]

Yes but it's not exactly what he needs ...

[omarlq20]

Not exactly what I need, clearly, if you like what I require, but I need the totals to be displayed as a single field.