Drill down and drillup

[Former Member]

Hi All,

I have a requirement that below are the two tables

Col1 Col2

-

---

-

---

A 40

B 45

Col1 Col2 Col3

-

---

-

---

-

---

A X 10

A Y 20

B V 20

B W 30

I want to perform the Heirarchy on the above tow tables

Not: Agregare awareness doesn't work becuase here values shouldn't be aggregate

Note : If you observed for A in table 1 value is 40 but in table 2 the value of A is 30(10+20) only

Thanks inadvance

[Former Member]

Hi All,

any help greatly appreciate

Thanks in advance

[Former Member]

How is the first table related to the second?

Are the measures meant to add up or is it different data?