Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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