Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extracting data from 2 pivots
I am trying to extract data from 2 different pivots.
Pivot 1 Pivot 2 Result outside of Pivot Id1 Id2 Value Id1 Id2 Value Id1 Id2 Value 1 dd 100 1 dd 300 1 dd 400 gg 550 gg 230 gg 780 2 dd 300 2 dd 100 2 dd 400 gg 300 ss 50 gg 300 ss 100 3 .... ss 150 3..... 3 .... I can make them static with simple sum-formulars, but I need someting that gets the ID data from the two Pivots and then sum the values. The trick is that it is not the same data that the two pivots are returning. Sometimes there are "gg" in ID2 and I need the formular to take into consideration that these can change over time without me having to change the formulars. I hope you can help me with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from two columns | Excel Discussion (Misc queries) | |||
Extracting data | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |