akirajt
Right there with Babe
Points: 762
More actions
November 6, 2013 at 2:34 pm
#300813
Goal:
Make the three last row with value(1239, 1551, 4776) to use decimal value (xx.00)
Problem:
What guideline can you provide to do it?
Information:
*Using SSRS 2012
*The datasource is SSAS
*New data will be added every month.
Mohamed I.
SSCrazy
Points: 2774
November 8, 2013 at 3:27 pm
#1665241
Hi,
Maybe you can use Rownum and Rowcount function ?
IF Rowcount - Rownum >= 3 THEN highlight ELSE do nothing
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
SGT_squeequal
SSCertifiable
Points: 7167
November 8, 2013 at 4:31 pm
#1665249
Look up row_number () over ( partition) run through a cte and return only the rows you need
***The first step is always the hardest *******
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply