indexing

Question

Hi everyone,I have a problem and cannot solveWe have 2 offline shops, Shop A and Shop B, every shop have its own sales sorted by date.I want to index that sales by date and by shop.&nbsp;&nbsp;example:Shop name&nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;IndexShop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15/12/18 12:14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Shop B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15/12/18 13:55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Shop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15/12/18 19:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2Shop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16/12/18 10:11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3Shop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16/12/18 10:14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4Shop B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16/12/18 14:20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2Shop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16/12/18 18:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5Shop B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17/12/18 17:50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3Shop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18/12/18 12:01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp;......&nbsp;Thanks for any help

zubair_muhammad · Accepted Answer

Anonymous
&nbsp;
One way could be to use&nbsp; a calculated column
&nbsp;
Column =
RANKX ( FILTER ( Table1, [Shop name] = EARLIER ( [Shop name] ) ), [Date],, ASC )

Forum Discussion

indexing

2 Replies

Related content

Multiple conditions Index

Index

Fixed Index Column

Index Key

Index Countif