Need to color code cells based on Year Range

[sdmech81]

HI,

We have data like below (sample data )

The expected results is as below: (We need to color fill based on condition the background in Table  using above data.)

looking for working solutions. Thanks

[AshutoshBhumkar]

Hello,

Maybe below sample will help.

Table:
Load * Inline [
ID, Start, End
ABC,2020,2024
PQR,2022,2027
LMN,2025,2030
ABC,2026,2030
];

NoConcatenate
Table2:
Load
ID,
Start + IterNo() - 1 as StartEnd
Resident Table
While IterNo() <= End - Start + 1 ;
DROP Table Table;

Exit Script;

Output:

Row : ID

Column : StartEnd

Values : Count(StartEnd)

Background Color of Values : If(Count(StartEnd)>0,Blue())

Thanks,

Ashutosh

[sdmech81]

Thanks ..its works