Hello Guys!
I am working on a dashboard with a pivot table and I am trying to make it as automatic as possible.
To do so, I would like to be able to activate different pivot fields (data, which corresponds to a specific week).
The weeks' data are put into different columns.
e.g. If I want to see the data (the pivot items) of week 3 (pivot field), all the other weeks should be hidden except this one. There is a variable "Week 3", which should be used to activate the corresponding data (by coding and not clicking manually in the pivot table).
For now, I am only able to make items visible, but not entire fields in one time. And a double loop is very time consuming (huge table). Any idea to solve this?
Thanks a lot!
I am working on a dashboard with a pivot table and I am trying to make it as automatic as possible.
To do so, I would like to be able to activate different pivot fields (data, which corresponds to a specific week).
The weeks' data are put into different columns.
e.g. If I want to see the data (the pivot items) of week 3 (pivot field), all the other weeks should be hidden except this one. There is a variable "Week 3", which should be used to activate the corresponding data (by coding and not clicking manually in the pivot table).
For now, I am only able to make items visible, but not entire fields in one time. And a double loop is very time consuming (huge table). Any idea to solve this?
Thanks a lot!
