Hi All,
I'm looking for a way (if possible) to allow my filters in a pivot table be based off of an "if" statement or something similar. The data that i'm pulling from is a little complicated to write out... but here goes nothing.
I work at a hotel and every night there is a snap shot of what...