Skip to Content
0
Former Member
Oct 27, 2012 at 08:13 PM

How to Count duplicate object after hiding duplicate values in a row???

36 Views

Hi i am stuck on this problem from past few days. my table looks like the one below.

Here i have Service No, Date and Count for Service No.

The formula i used to Count Service No is =Count ( [ Date ] ) In ( [ Service No ] )

in above table Service No have repeating values based on different date.

so now i was suppose to show Service No with most recent Data avoiding all duplicate vale.

So i created 2 variable

1. Var_RankingNumber: =Rank ( [ Date ]; ( [ Service No ] ;[ Date ) ;[ Service No] )

2. Var_RankingString : =FormatNumber ( [Var_RankingNumber] ;"#" )

Then on screen level filter i made Var_RankingString equals to 1. Which gave me the table below

Until now everything works fine for me and i was able to filter Service No based on most recent date.

My problem is with Count Service No where i want my table to like the table below

I want to include the original count of all the Service No as it was before hiding the duplivate vale.

Please guide me what should i do to get the desired results .

Thank You

Attachments

1.JPG (29.9 kB)
2.JPG (16.1 kB)
3.JPG (16.0 kB)