Security Access Right Hide Change Field Values.

[ch_riadh]

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.

[Anil_Babu_Samineni]

Check if that helps? You can create KPI's based on my table?

Update - Check with KPI's as well.

Sections Access Script

[Anil_Babu_Samineni]

Did you get a chance to look?