cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Azat Regular Visitor
Regular Visitor

indexing

Hi everyone,

I have a problem and cannot solve

We 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. 

 

example:

Shop name     Date                       Index

Shop A           15/12/18 12:14         1

Shop B           15/12/18 13:55         1

Shop A           15/12/18 19:00         2

Shop A           16/12/18 10:11         3

Shop A           16/12/18 10:14         4

Shop B           16/12/18 14:20         2

Shop A           16/12/18 18:30         5

Shop B           17/12/18 17:50         3

Shop A           18/12/18 12:01         6

 

......

 

Thanks for any help

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: indexing

@Azat

 

One way could be to use  a calculated column

 

Column =
RANKX ( FILTER ( Table1, [Shop name] = EARLIER ( [Shop name] ) ), [Date],, ASC )
2 REPLIES 2
Super User
Super User

Re: indexing

@Azat

 

One way could be to use  a calculated column

 

Column =
RANKX ( FILTER ( Table1, [Shop name] = EARLIER ( [Shop name] ) ), [Date],, ASC )
Highlighted
Azat Regular Visitor
Regular Visitor

Re: indexing

thank you, appreciate