In a Pivot Table is it possible to have a Row above the Dimension/Expression Header.

[#1]

Hi

In a Pivot Table is it possible to have a Row above the Dimension/Expression Header.

Regards,

Rohit

[sparur]

Hello, Rohit.

I think it's impossible now.

[#3]

Hi rohita, can you elaborate?

[#4]

Thanks Matt for showing interest.

The 1st row in a pivot table is the header which shows either Dimension Header or Expression Header.

I would like to have a Row above these header rows and would like to display some text.

I hope its clear now. Please let me know if more information is required.

[bumin]

Hi Rohit,

I am struggling with the same problem. Have you got any solution?

I tried to do it with a sepate table (temp1)

have a look to the sheet "table with header row"

regards

Bumin

[#6]

Hi Rohita,

How do you want this row. Just a simple line or with cell like the pivot table? can u show a snapshot of what you are trying to achieve?

-Sana

[bumin]

Hi Sana,

this is what I need

Customer 1	Lincolnstreet 1	Washington
invoice 1	invoice no	100
invoice 2	invoice no	200
invoice 3	invoice no	300
Customer 2	Marx-Center	New York
invoice 1	invoice no	104
invoice 2	invoice no	205
invoice 3	invoice no	800
Customer 3	Obama-Allee 7	Chicago
invoice 1	invoice no	750
invoice 2	invoice no	220

regards

Bumin