Section Acces and OMIT

[DaanBrand]

Hi all,

I have a question about the possibilty to combine Section Acces and Omit.

Please look at the data below:

ACCOUNT	EUR	KG
SU	10000	1000
AH	20000	2000
JU	30000	3000

I would like to have USER1 seeing all the data (EUR and KG) of ACCOUNT SU and only the KGs of all the other accounts.

• If I use Seccion acces on ACCOUNT SU all data of AH and JU will be unvisible for USER1
• If I use OMIT on field EUR the total EUR column will be unvisibile for USER1.

So I'm looking for a combinatie between those tho options.

The data has to be as follows:

ACCOUNT	EUR	KG
SU	10000	1000
AH		2000
JU		3000

Can anyone help me with this problem?

Thanks in advance..

-

Daan

[YoussefBelloum]

Hi,

I think you will need to make a crosstable using your existing table to transform your Currency type as a field..then you can use it as a reduction field