A
And_Usa
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.
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.