pivot table HELP

%3CLINGO-SUB%20id%3D%22lingo-sub-3538379%22%20slang%3D%22en-US%22%3Epivot%20table%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3538379%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20making%20a%20graph%20that%20has%20to%20show%20the%20displacement%20for%2044%20monitoring%20probes.%20the%20probes%20slightly%20move%20every%20hour%20and%20is%20recorded%20at%20the%20hour.%20I%20have%20over%2045K%20data%20points%20and%20more%20coming%20in%20daily%2C%20thus%20i%20made%20a%20pivot%20table.%20my%20basic%20table%20looks%20good.%20BUT%20i%20need%20to%20be%20able%20to%20take%20the%20displacement%20of%20each%20point.%20the%20problem%20is%20each%20monitoring%20probe%20starts%20at%20a%20different%20location.%20the%20data%20isn't%20sorted%20by%20probe%20so%20i%20cant%20just%20make%2044%20different%20excels.%20Any%20ideas%20how%20to%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eto%20simplify%2C%20overall%20equation%20i%20need%20is%20just%20Xo-Xf%2C%20but%20Xo%20is%20dependent%20on%20the%20probe.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3538379%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epower%20bi%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am making a graph that has to show the displacement for 44 monitoring probes. the probes slightly move every hour and is recorded at the hour. I have over 45K data points and more coming in daily, thus i made a pivot table. my basic table looks good. BUT i need to be able to take the displacement of each point. the problem is each monitoring probe starts at a different location. the data isn't sorted by probe so i cant just make 44 different excels. Any ideas how to do this? 

 

to simplify, overall equation i need is just Xo-Xf, but Xo is dependent on the probe. 

0 Replies