Pivot table format

[sankar_ganesh]

Date	Product	Sales
27-Oct-14	P1	10
27-Oct-14	P1	5
28-Oct-14	P1	20
28-Oct-14	P1	30
27-Oct-14	P2	20
27-Oct-14	P2	15
28-Oct-14	P2	20
28-Oct-14	P2	40

Hello,

Above is the sample source  data of my qlikview report, from which I need to create the table given below.

Here Sales is the sum(Sales) of the source data and the difference is the diff. of Sales b/w the two products. Is this possible ? Could some one give suggestions .. Thanks!

	P1	P2	Differrence
Sales	65	95	35

Regards,
Sankar

[ajaykumar1]

Hi ,

The same format seems not possible as per my knowledge because we can arrange the Horizontally in Pivot only.

But when we arrange horizontally we will not get the exact data o/p you want.

In straight we will get the o/p but not in horizontal way.

Please correct me if am wrong.

Thanks,

Ajay

[diwakarnahata · Accepted solution]

Hi,

See if this works for you.

[#4]

Attached should suit requirements

[Kushal_Chawda]

May be like this

[sankar_ganesh]

It works! Thanks for all of your responses!

Cheers,
Sankar