Dynamic Header/Label in Pivot Table

[#1]

Hi All,

I'm having a hard time creating the report format below:

Just want to ask if this is possible? When I put in the months, I'm having trouble making the LABEL dynamic.. If I make the label dynamic and create multiple formulas (7 formulas), the months repeat.. is there a way to hide/workaround that I can do to achieve this report format?

Thanks,

Donat

[avinashelite]

check this

multi_header_pivot_import.qvw

[Gysbert_Wassenaar]

You can't make the expression column headers dynamic. If you want such headers you'll have to use text boxes and place them on top of the pivot table.

[#4]

so that's the only workaround ;(

[jagan]

Hi,

You can try ValueList() as the dimension, it is not possible with the existing features.

Regards,

Jagan.

[#6]

is there any possibility when I send to excel I'll be able to insert rows above

[jagan]

You have to try macro, but it is very difficult.  Can you attach some sample data so that it would be easier to give a try.

Regards,

Jagan.