Ignoring repeating values in staright table

[montubhardwaj]

Hello all,

I have a staright table and in which I need to ignore the repeated combination of (Dept Id+Ord Id) if more than once. See below for more explanation.

Show count as '1' if it is a unique Dept Id and Ord Id.  If Dept Id+Ord Id is repeating, then just put ‘1’ only for the first value and put ‘N/A’ for the remaining values.Please refer to the below attachment for more. Please let me know how we can implement this logic in the chart (straight table)?

Thanks in advance.

Cust ID	Dept ID	Ord Id	Sales(in $)	Count
			43000	6
1	A1	100	5000	1
2	A2	200	7000	1
3	B1	300	6000	1
4	B1	300	8000	N/A
5	B1	300	9000	N/A
6	B1	700	9000	1
7	C2	400	4000	1
8	C2	400	3000	N/A
9	D1	600	1000	1

Regards,

Sharma

[lironbaram]

hei

try this one

hope its helps you

[montubhardwaj]

Hello Liron,

Your logic works fine in sample application but when I implemeneted the same in my application, it is not working as desired. Dont know where I am making the mistake

[lironbaram]

hei

attach is an example pf calculating your logic in the script

may be you can use it

[sridhar240784]

Sharma,

Could you post your sample application which will explain your problem in detail.

-Sridhar

[montubhardwaj]

HI Liron,

Thx for the response. Actually in my real report, I have many fields in the table(around 20). So does that mean I have to pull all the fields in order by clause to make it work ?

[lironbaram]

you need to order only the fields that are relvant  an you need sorted

for example if you have client name you do not need to sort it

can you post a sample data