Re : Heading in pivot table

[#1]

     Hi All..

i need to create a pivot table as follows

Here Discipline is the dimension and Rest all are Expression

i have to create an additional Heading ,(Productivity,Lock Up etc..) for specific Expressions as shown below.

is there Any possible way to achieve this??

please suggest..

[sunny_talwar]

You can use ValueList() function to create a new dimension:

Something like this:

ValueList('PRODUCTIVITY', 'LOCK UP' and so on...)

and then use that within your expression like this:

If(ValueList('PRODUCTIVITY', 'LOCK UP' and so on...) = 'PRODUCTIVITY',

yourExpression) for your Hours expression

HTH

Best,

S

[awhitfield]

Or use a text box with the heading in

[#4]

hii..

I tried tht ..bt it is nt working.all values are coming under the same.

[sunny_talwar]

Are you using the same if for all of them? For Dbors TOTAL you need to do like this:

If(ValueList('PRODUCTIVITY', 'LOCK UP' and so on...) = 'LOCK UP',

yourExpression) for your Dbors TOTAL expression.

Need to make sure that you select the correct place to put your expressions.

Let me know if it is still not clear.

Best,

S

[#6]

yea,...i have done the same. in expression field i have given the same.

[#7]

HII...

ANY HELP ON THIS.. PLEASE...

[awhitfield]

Have you tried my Text box idea?

Andy

[#9]

hi..

but while exporting to excel the text box cannit be exported ..so i cant use tht way...

[sunny_talwar]

So I have this thus far. May be somebody knows a way to remove the empty columns where all the values are null. i tried doing suppress null value but that did not help. Attaching my qvw for others to play with.

Best,

S