dinamic columns

[Anonymous]

hi,

i build pivot table, and i want that only one columns will be chenge with my Choice - month.

see attuched xls, the columns that i want that will be open is - D.

exmp:

in the file i chose decmber so i see only one month.

i will chose october - december i expect to see colums for each month ,

the other columes will be pushed.

hope it's understood.

thanks'

yarin.

[#2 · Accepted solution]

You need to use conditionals.  See attached.

[Anonymous]

hi,

you are great!!!

if will see you i will kiss you.

thanks' alot you help me more then you think.

yarin.