How to highlight the cell in table for starting of month-year

Question & Answer
,
1

Hi experts,

I need to highlight the starting of the PERIOD (date field) with a background colour (red boxes in below SS) in table cell.

How this can be achieved ?
Here the problem is that I may be having same starting period for diff partners but I need to just highlight the first one.

image
image588×639 52.6 KB

Here FINTECH PARTNER and PERIOD are my Group By fields and remaining calculations are under Values in table.

2

Hi @Vaibhav_Patidar,
I would suggest creating a ranking of your Period, aggregated by your Fintech Partner field. That way. Then when creating your conditional formatting for the ‘Period’ field; for the ‘format based on’ option, choose your rank calculated field and set it equal to ‘1’ so that it only highlights the first ranking (first date per partner).

Let me know if this works for your case or if you have any additional questions

3

Hi @Vaibhav_Patidar,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @Vaibhav_Patidar,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!