Add Sales Table into GL Table For achieve drill in on sales by customer

[paulyeo11]

Hi All

I have a GL Table which working fine , and i able to plot sales Amount By month.

In my GL Table , i have a field name = ACC_NAME

Which i recode ACC_NAME into :-

1 REVENUE

2 COGS

3 OTH INCOME

4 PAYROLL ADMIN

7 GEN EXP ADMIN

8 PAYROLL S & D

9 STAFF WELFARE S & D

10 COM S & D

11 SALES & PROMOTION

12 GEN EXP S & D

So when i Click on 1 REVENUE , it will select all sales data only from GL TABLE.

Enclosed my data model for your info.

[paulyeo11]

Hi All

Now my sales table also able to plot sales by month. and GL TABLE also can plot sales by month.

Enclsoed my data model after i add the sales table.

[paulyeo11]

Hi All

My issue is when i select ACC_NAME=1 REVENUE

How to make it i also can select all my SALES TABLE data , now all data are disable.

Paul

[paulyeo11]

Hi All

Thank you i found the issue , i need to create a filed name ACC_NAME at my sales table in order to prevent sales table from disable when i select 1 REVENUE.

Paul