Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to show only common stores between two consecutive months .
Jan to Feb, Feb to March, March to April and so on ... using set analysis..
YearMonth | Stores OverAll | #Common Stores |
---|---|---|
201801 | 699 | 0 |
201802 | 1000 | 300 |
201803 | 700 | 500 |
MonthNum: 1,2 3,.....
=count(Distinct {<MonthNum={'$(=vCurrentMonth)' or MonthNum={'$(=vLastMonth)'>}>}StoreCode)
Please suggest
Hi,
one idea :
make a pivot table with yearmonth and storecode (in horizontal)
then expression :
above(count(distinct storecode)) // storecode present prior month
and you sum it
regards
can you provide a sample
Can you attach the sample data and expected result?
no I cant due to security reasons
You can send some sample data instead of original data.