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!

[#2]

Hi, another additional question need your help...

How could I remove the 'Product' column? Since I use the pivot table...

[alexandros17]

you cannot hide it because you have a pivot ... the only way is to delete it from dimension and for each expression use aggr( ....., Product)