Hi everyone,
i would like to kindly ask you for your help pls.
how to set up filter in pivot table based on cell values without changing raw data?
lets say that in column A i have following values
Countries:
Romania
Russia
Denmark
and these countries should be automatically selected in pivot table filter - as i do not care about the other countries, how can i do that? Also some more countries could be added, any idea pls how i could do/create automatic filter based on cell values? Also is it possible to do it without vba?
Many thanks.
Regards,
Tommy
i would like to kindly ask you for your help pls.
how to set up filter in pivot table based on cell values without changing raw data?
lets say that in column A i have following values
Countries:
Romania
Russia
Denmark
and these countries should be automatically selected in pivot table filter - as i do not care about the other countries, how can i do that? Also some more countries could be added, any idea pls how i could do/create automatic filter based on cell values? Also is it possible to do it without vba?
Many thanks.
Regards,
Tommy