Imagine I have a quality control in a factory retrieving the state of each product
1 – Good
2 – Acceptable
3 – Subproduct
4 – waste
My table 'StateIdHistory' gives me the state of each ProductId at each time.
I am creating a pivot table in which I want to filter out the StateId=3 in a specific datarange. so I filter my report selecting "3".
Imagine I want to use this same model to other database in which there isn't any StateId=3. My data model will be destroyed. Can I somehow fix the filter to be equal to 3 in spite of having or not data? VBA? If 3 still does not exist it would retrieve me 0 or blank cells…
Thanks in advance!!