Post reply

Format the Last Three Row

  • 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.

  • 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:

  • 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