Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I obtain a straight table with the number of duplicated stores ?
Thank for your help.
Judikael.
Try Straight table..
Dimension = Store
Expression = COUNT(Distinct Month)
or
COUNT(DISTINCT {<NbrStore = {'>0'}>} Month)
Hope this helps..
Duplicated in what context? Or how do you get e.g. the number 7 for store A01?
When I select store A00, I see nov, oct, sept, aout, juil and juin so 6 for A00.
I want to obtain the list of duplicated store by year or by month if there are duplicated by month in the straight table .
Try Straight table..
Dimension = Store
Expression = COUNT(Distinct Month)
or
COUNT(DISTINCT {<NbrStore = {'>0'}>} Month)
Hope this helps..
Hi Manish,
It works well.
Thanks.