Serial Number

Hi Williams,
I need some clarification regarding serial no
I have a column which is integer type and this column has duplicate values,
My requirement is like i dont need to display serial no for the duplicate values.

S.No. column
1. 21
21
21
2. 32

I want to display like this.
Please help me for this issue.

Thanks,
J.Raghu

Find more posts tagged with

Comments

lrnrit

<blockquote class='ipsBlockquote' data-author="'Raghuvj'" data-cid="93380" data-time="1325491964" data-date="02 January 2012 - 01:12 AM">
Hi Williams, 
I need some clarification regarding serial no 
I have a column which is integer type and this column has duplicate values, 
My requirement is like i dont need to display serial no for the duplicate values. 
 
S.No. column 
1. 21 
21 
21 
2. 32 
 
I want to display like this. 
Please help me for this issue. 
 
Thanks, 
J.Raghu </blockquote>
 
 
Hi Raghu 
 
You can achive this by adding one group over valuve column and add one aggregation taking its Distinct count which will be one per group and take another aggreation over table to give running sum as serial no. 
 
Check the design file. 
 
lrnit

Raghuvj

Hi,
I am new to this,
can u explian step by step and my requriment is like

s.no rank name
1. 1 raghu
2. 2 vamsi
2 rahul
2 ramesh
3. 3 suresh

Raghuvj

you have created the function "Count Distinvt group"
can u explain about that.
can u clearly guide about that.

Raghuvj

Hi Arun,
I followed the steps based on ur attachment.
But i am getting the output in different format.
can u please help me on this issue.

lrnrit

<blockquote class='ipsBlockquote' data-author="'Raghuvj'" data-cid="93385" data-time="1325506515" data-date="02 January 2012 - 05:15 AM">
Hi Arun, 
I followed the steps based on ur attachment. 
But i am getting the output in different format. 
can u please help me on this issue. </blockquote>
 
Hi, 
sorry forget to mention that in group header field cell(Serial No) Drop is set to detail . 
 
"Count Distinvt group" column binding is used to give 1 value to all distnct sets of value, So that there sum could be used for serial no. 
 
What else you want to do with you representation. Can you explain it bit more. 
 
lrnit

Raghuvj

<blockquote class='ipsBlockquote' data-author="'lrnrit'" data-cid="93388" data-time="1325507137" data-date="02 January 2012 - 05:25 AM">
Hi, 
sorry forget to mention that in group header field cell(Serial No) Drop is set to detail . 
 
What else you want to do with you representation. Can you explain it bit more. 
 
lrnit </blockquote>
 
HI Arun, 
Have u seen the attachment of my previous post, 
the serial no is coming in other row, but in ur example it is coming in the same row, 
can u help on this issue. 
I tried in different ways,but i unable to solve that.

lrnrit

<blockquote class='ipsBlockquote' data-author="'Raghuvj'" data-cid="93389" data-time="1325507914" data-date="02 January 2012 - 05:38 AM">
HI lrnit, 
Have u seen the attachment of my previous post, 
the serial no is coming in other row, but in ur example it is coming in the same row, 
can u help on this issue. 
I tried in different ways,but i unable to solve that. </blockquote>
Hi 
 
 
 
Set Drop for cell of serial no to Details. First Select the Cell not Data of Serial no and In general properties you will find this . 
 
 
lrnit

Raghuvj

<blockquote class='ipsBlockquote' data-author="'lrnrit'" data-cid="93390" data-time="1325508324" data-date="02 January 2012 - 05:45 AM">
Hi 
 
 
 
Set Drop for cell of serial no to Details. First Select the Cell not Data of Serial no and In general properties you will find this . 
 
 
lrnit </blockquote>
Hi Arun, 
THANKS FOR UR HELP.

lrnrit

<blockquote class='ipsBlockquote' data-author="'Raghuvj'" data-cid="93391" data-time="1325509862" data-date="02 January 2012 - 06:11 AM">
Hi , 
THANKS FOR UR HELP. </blockquote>
 
 
I am glad , I could Help. 
 
lrnit