How do I show repeat values in Pivot table? 1

[UongSaki]

Sum of Total Cost Center
NTDA CE Cost Element 11000 11002
640100 501000
501001 490639.72 115753.3
501006
501007
501011
501012
501014
501998 890.89 445.2

I would like to have the 640100 value repeated.

Thanks,

Saki

 

[KenWright]

Can't really do that within the Pivot Table as it is and keep everything dynamic (at least I don't think you can), but if you copied and pasted your report as a hardcoded report then you could fill in the blanks using the method at the following FAQ:-

faq68-4741

Regards
Ken...................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[UongSaki]

Thank you. It's much better than with a copy & paste that I've been using.

Thanks,

Saki

 

[KenWright]

You're welcome

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------