Seperate Pivot table into autonomous subset tables?
Hi QVer, I have a Pivot table with first dimension (ID=A, B, C, D etc.). From this source I want autonomous tables only showing subsets i.e. for ID=A or ID=B+D etc. and - after filtering - they should function as autonomous Pivot not depending on the selection of the source table. I tried to use properties > seperate [Trennen in german] but when closing and reopening the document this seperation disappeared and all tables are showing the same like the source. How can I manage this? Only possible with hard coding via expression, set analysis etc.? Can anybody help me please or point me to a post here? Thanks. dj_skbs
