Sum of results of an expression in SSRS

  • Hi,

    I have the below expression in result i am getting values for each month. Now, I want to calculate the sum of those results for all the months (Which i am already getting using the expression).

    Also, I want the difference between the present and the past month from the result using the same expression.

    Please help me...

    The expression is ....

    =IIF(Sum(IIF(Fields!Naming.value="Total Tickets",Fields!Totals.value,0))>0,Sum(IIF(Fields!Naming.value="Laptop Tickets",Fields!Totals.value,0))/Sum(IIF(Fields!Naming.value="Total Tickets",Fields!Totals.value,0)),Nothing)

    Regards

    Kishore

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply