Table distribution in QV

[#1]

Hi, I have a table shown as below.

year	Product	Sale
2011	A	Percentile(A,0.5)
2011	B	Percentile(B,0.5)
2011	C	Percentile(C,0.5)
2009	A	Percentile(A,0.5)
2009	B	Percentile(B,0.5)
2009	C	Percentile(C,0.5)
2008	A	Percentile(A,0.5)

How can i switch it to the table shown like this?

date	A	B	C
2011	Percentile(A,0.5)	Percentile(B,0.5)	Percentile(C,0.5)
2009	Percentile(A,0.5)	Percentile(B,0.5)	Percentile(C,0.5)
2008	Percentile(A,0.5)	Percentile(B,0.5)	Percentile(C,0.5)

Thanks so much!

[its_anandrjs]

Sorry for response late

Load cross table for the given data but you can use pivot table will be good idea for this

Take a pivot table

Dimension:- year

Dimension:- Product

Expression:- Sale

See the attached snap shot

After adding of the Dimension and Expression Drag a product dimension over the sales expression upper right corner of the chart for pivoting.

Regards

[alexandros17 · Accepted solution]

Here it is

[maxgro]

you can use a pivot chart with

dimensions     year

                     Product

expression     sale

[SunilChauhan]

use same as Massimo grossi

but Drag Product dimension from vertical to hozonatal at the top of Sale

Thanks

[#6]

Thanks All!

May be I did not describe my question clearly.

I want to get the median value of sale for the sale column. When I use the pivot table I could not Drag Product dimension from vertical to hozonatal at the top of Sale.

I use the cross table in the script for another table so is there anther method instead of cross table?

[alexandros17]

Have you seen my example?

Let me know!

[#8]

Yes! I have seen your example and I can drag the product in your example. But I could not drag when I put 'Fractile(sale,0.5)' for the Sale column.....

[#9]

I just copy your example and load my data, it works!!! I don't what happy with my previous one.....

Thanks so much for your help!

[alexandros17]

If you want you may mark my answer ...