Pivot table and List Box

[Frédéricdh]

I have a Pivot table and a ListBox which are linked with the dimension Week.

When I choose a week in the Listbox, I don't want that the pivot table change , I want that the pivot table show all the value, alle the week.

 How i do this?

thanks in advance.

[anat]

You can bypass week field in set analysis. 

Sum({<week= >}Field)

[Frédéricdh]

Thank you, it works, but in the Pivottable, I have 2 dimensions, the week and the facility. Andfor the facility I sort i with a function but now when I click a week in the list box, the order change and it doesn't follow the sort function I give.

Why?

[Frédéricdh]

My sort function works with Match(Facility, 'A', 'B', 'C')