is there a way to calculate the difference between cells vertically on top of each other in a google sheets pivot table using the calculated field? For example I have a list of vendors and their purchase order dates. What's the best way to calculate the difference in time between purchase order dates without having to do manual calculations. I'd love to have an active table running to quickly view in real-time.
![Google Sheets Slicer: How They Work & How to Add [Easy]](/img/n.gif)
is there a way to calculate the difference between cells vertically on top of each other in a google sheets pivot table using the calculated field? For example I have a list of vendors and their purchase order dates. What's the best way to calculate the difference in time between purchase order dates without having to do manual calculations. I'd love to have an active table running to quickly view in real-time.
Great video! Exactly what I need! ❤
thanks, very helpful
Good explanation. 💯
Excellent
thankyou!
You're welcome!
How to auto record live google sheet data to anther sheet evey 5 mints