Query on Aggr() function

[#1]

I am having 2 tables i.e. IB Table and Net Con Table as shown below.  In Net Con Table, value is available at BU Equi level, but in IB table not at that level.

IB Table
Col1	Col2	Col1/Col2
200	300	0.67

Net Con Table
BU Equi	Col1
MR	300
CT	500
ISR	600

Now, I have to create a bar chart where BU Equi is the dimension and my exp is (Col1/Col2) of IB Table * Col1 of Net Con table.

and also I have to Aggr() function to take the sum of rows in subtotal.

Please help me how I can achieve it.

Thanks.

[#2 · Accepted solution]

I don'e see any needed for AGGR function here. Its straight forward.

You tables associated on Col1 Key ? If Yes simply create the Bar chart with your expression: sum(Col1)/Sum(Col2) if BU Equi have more than one ditinct value  on Col1