Skip navigation

How to Intersect Dates in Tables with Highlighting

score 0
You have not voted. Archived

Hi All,

 

Please read the next sentence very slowly to understand each part of this table.

 

I'm trying to intercept a start date column(07/15, 07/23, 07/30) for a product release. I am using the week start date row(07/08, 07/15, 07/22, 07/29) for the date a customer bought a product in a data table with the number of customers that bought the product using intersection with highlighting.

 

The week start date represents the total number of customers that week and the actual date the customer bought the product.

 

                             07/08  07/15  07/22  07/29

07/15                        0          1         0         0

07/23                        0          0         1         1

07/30                        0          0         0         0

 

My goal is to highlight the 1st enrollment number(not including zero) of the start week and start date.

 

                              07/08  07/15  07/22   07/29

07/15                         0          1         0          0

07/23                         0          0         1          1

07/30                         0          0         0          0          <- 0 for this is not highlighted. Even though the start date lands on this week, there are no customers that bought the product. It would highlight the future week that a                                                                                      customer buys the product.

 

If anyone can figure a way to make this work, please share, I would greatly appreciate it!

 

Thank you,

 

Kyle Yates

Comments

Vote history