PDA

View Full Version : Dynamic Source Pivot



cookiea
06-30-2017, 09:14 AM
Hi!

I am trying to figure out the best way to pull the data I want for my pivot. My report is comparing current with changes...so I want a person to type 'yes' in the cell in order to see that change in the data versus the current. My pivot data pull would then say: If the 'yes', replace current data row with the change data row above it, else.. use current data row. Can anyone help with how to go about this?