Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
Very Urgent.
This is the Table i have.
TransactionCode | Company | Country | SalesAmount |
---|---|---|---|
01 | BMW | GERMANY | 50000 |
02 | BMW | GERMANY | 60000 |
03 | BMW | GERMANY | 90000 |
04 | VOLKSWAGEN | GERMANY | 50000 |
05 | MERCEDES | GERMANY | 100000 |
06 | PORSCHE | GERMANY | 150000 |
07 | FORD | USA | 90000 |
08 | FORD | USA | 80000 |
09 | CHEVROLET | USA | 30000 |
10 | RENAULT | FRANCE | 20000 |
11 | RENAULT | FRANCE | 30000 |
12 | CITROEN | FRANCE | 40000 |
13 | PEUGEOT | FRANCE | 10000 |
When i Access my app with BMWuser, i want to See:
Table:
Company | Country | SalesAmount | |
---|---|---|---|
BMW | GERMANY | 200000 | |
Germany Car 1 | GERMANY | 50000 | |
Germany Car 2 | GERMANY | 100000 | |
Germany Car 3 | GERMANY | 150000 | |
USA Car 1 | USA | 90000 | |
USA Car 2 | USA | 80000 | |
USA Car 3 | USA | 30000 | |
France Car 1 | FRANCE | 20000 | |
France Car 2 | FRANCE | 30000 | |
France Car 3 | FRANCE | 40000 | |
France Car 4 | FRANCE | 10000 |
KPI's:
BMW sale amount = 200000
Total Germany Car sales = 50000 + 100000 + 1500000 = 300000
BMW sales / Total Germany Car sales : 200000 / 300000 = 66 %
Total Sales Of All Company in ALL Countries = 800000
BMW sales / Total Sales Of All Company in ALL Countries : 200000 / 800000 = 25 %
Thanks in advance.
Check if that helps? You can create KPI's based on my table?
Update - Check with KPI's as well.
Sections Access Script
Did you get a chance to look?