Hello,
I have a listbox filter with numbers as values and a pivot table.
I have also 5 numbers, which are not displayed in the listbox, so you can not select them.
Listbox selection is represented like one of dimensions in my pivot table.
I need these 5 numbers, which are not visible in the listbox to appear always in the pivot table together with the selection from the listbox.
This dimensions is not aggregated , just a field with no formulas applied.
How to do this?
Best Regards,
D. Petrov