Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can bypass week field in set analysis.
Sum({<week= >}Field)
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?
My sort function works with Match(Facility, 'A', 'B', 'C')