WebI Variable help

[former_member648413]

Hi All,

Can someone help me in creating a variable for this column?

I have created the first 4 columns. I am trying to create CPRO Count CY.

How to make sure the variable is picking the date for Current year/previous year from column correctly for that column?

CPRO Count CY - To Calculate this - I have "CPRO Indicator =Yes" and I have a "Count Column" already.

I need to do - RO Count where CPRO Indicator = Yes for each CY date(Date Column) value showing in the attachment.

[former_member648413]

Please find the attachment.