Column Alert

[sureshlella]

Hi BO Gurus,

Please can anyone help me out of this situation. i am not very good in creating alerts.

Requirement

I have colummn from 01 to 24 for each hour and i have another column which gives peak_hour value. based on the peak hour column i have to highlight that column which is equal to peak_hour value using alerts. Can i highlight a specific column in a row. its not cross tab report.

01 02 03 04 05 06 Peak
DAY1 158 166 209 244 349 203 349
DAY2 89 96 67 110 100 45 110


Cheers
Suresh

 

[blom0344]

Create variable 'X' like:

= max(<value>) in (<day>)

Then create an alerter that evaluates whether value = 'X'

Seems to work fine in a crosstab, not tested on a table..

Ties Blom

 

[sureshlella]

Cheers Blom,

Yaa its not cross tab report. So I did it in other way. I had to create alert for each hour(24 Alerts). Its done now.

Suresh.