how to give heading for expressions

[#1]

Hi,

i am having 3 dimensions and 8 expressions in pivot table,i want to give the some text information in expression heading.4 expression in 1 text information

and 4 expressions in 1 text information.for ex..

Closing Stock Share				Tertiary Sales Share
Jan-12	Dec-11	Nov-11	Oct-11	Jan-12	Dec-11	Nov-11	Oct-11
0.53%	0.31%	0.49%	0.97%	0.36%	0.50%	0.66%	0.87%
0.03%	0.07%	0.01%	0.16%	0.09%	0.03%	0.09%	0.31%
3.06%	1.97%	0.34%	0.05%	2.49%	0.66%	0.32%	0.03%
0.40%	0.34%	0.27%	0.30%	0.99%	0.95%	0.40%	1.23%
12.30%	12.00%	10.88%	10.70%	14.24%	17.26%	12.76%	13.66%

  here closing stock share and tertiary sales share i want to display as a expresions heading.

here jan-12,dec-11,nov-11,etc...is the calculated expresion name i taken in heading

regards,

ba

[v_iyyappan]

Hi,

     Cau u attach a sample QV file?

Iyyappan

[Jason_Michaelides]

What exactly do you want the expression headings to say?

[#4]

Hi

I want to display Closing Stock Share and Tertiary Sales Share as a expressions column names,under these i want to show 4 expressions for each heading like Jan12,Dec11,Nov11,etc..but it is calculated expression names.

pls find the above table,

reg,

ba

[jonathandienst]

Hi ba

You can get the look you want using a pivot table. Set up the two heading rows in your examples as dimensions, and drag to the top of the table.

Its best if the dimensions are field names but if you cant load them in script, you can use calculated dimensions. If you need help with the calc dimensions, then you will need to be more specific about your requirements.

Regards

Jonathan