Report Filter of Pivot Table--- Can you move location?

[PP3321]

I want to move the location of Report Filter of Pivot Table...
is it possible...?

For example,
I want to insert 1 more row between Value and Report Filter...

 

[Chihiro]

Instead of using Report Filter, use Slicer. Those can be moved around.

If you want dropdown style list, you need to create additional pivot and link that to Slicer. Link below explains in detail how to do it.

http://dailydoseofexcel.com/archives/2014/08/16/sync-pivots-from-dropdown/

 

[Luke M]

Not really. You could insert another field into Page Field, with lower status than the first, and that would create an extra row like this:


Then you could maybe format A2: B2 to be clear to hide the extra box?

Side note, why do you want to do this?

EDIT. Nice one @Chihiro !

 

[PP3321]

Hey thanks... I just want to add extra text to comment on the value. But I guess default is that we can not insert row or column into Pivot Table, right?

 

[Luke M]

Correct. I'd suggest either putting it to the side, or using the 'Insert comment' option. Not as good, but perhaps?

 

[candybg]

You might consider a TEXT BOX (Insert - Text Box) to give you a place for your additional explanations. You can place it where you want it as it is actually sitting above the data plain.