Custom Pivot table results
 

Hello All,
I am created a Pivot Table and when i dblclick on a Cell (which
contain Sum Value of Data) it display result in a new sheet with all
columns (which have original data).
now i want when i click on that cell it display result in new sheet
but limited columns (set by me)
is it possible if yes kindly help me.
Thanks in advance
Dev

Custom Pivot table results
 

Dev

Not possible through the UI, it will always display all columns in the
dataset

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"Dev" wrote in message
ups.com...
Hello All,
I am created a Pivot Table and when i dblclick on a Cell (which
contain Sum Value of Data) it display result in a new sheet with all
columns (which have original data).
now i want when i click on that cell it display result in new sheet
but limited columns (set by me)
is it possible if yes kindly help me.
Thanks in advance
Dev