Identify store

[#1]

Hi all,

How can identify if store are repeat in the current period for example : ST1,ST5.

And how can I count them ?

Thanks for your help.

Judikael,

[Anonymous]

Hi, what do you want to do when you've identified those? You just want to count the duplicated ones in the table?

[#3]

Hi Oscar,

Yes. count duplicated ones in the table and which store are duplicated.

[MK_QSL]

Temp:

LOAD * INLINE [

Year, Month, Store, NBR

2014, janv, ST1, 20

2014, fevr, ST2, 18

2014, mars, ST1, 16

2014, avr, ST4, 10

2014, mai, ST5, 25

2014, juin, ST3, 10

2014, juil, ST7, 20

2014, aout, ST5, 16

2014, sept, ST9, 1

2014, oct, ST10, 9

2014, nov, ST11, 1

2014, dec, ST12, 1

];

FINAL:

Load

  *,

  IF(Store = Previous(Store), 1, 0) as Flag

Resident Temp

Order By Store;

Drop Table Temp;

Now Create a Text Box with Expression = SUM(Flag) or SUM({<Flag = {1}>}Flag)

UPDATE : To get the distinct Duplicated Store.. use below in Text Box..

=COUNT({<Flag = {1}>}DISTINCT Store)

To find the Store Name...

=Concat({<Flag = {1}>}DISTINCT Store, ', ')

[Anonymous · Accepted solution]

Please see if the attached is what you are looking for.

    I've added a calculated dimension using aggr function. Let me know if you ahve any question.

Kind regards,

OM

[#6]

Thanks OM!!

Exactly what I mean.

Many thanks again.