Calculate percentage of growth within columns grouped in SSRS
I am currently building a report that includes a table with columns grouped by Month, so that it dynamically creates a column for each month that is within the range selected by the user.
What I'm trying to do, is that along with each column of Valuation , show one of Growth to put the percentage. For this, the value of [SUM (Difference)] of the previous month should be taken as 100% to be able to make the rule of three.
[SUM(Diferencia)] Enero = 100%
[SUM(Diferencia)] Febrero = x
[SUM(Diferencia)] Febrero = 100%
[SUM(Diferencia)] Marzo = x
The formula I am using for this is the following:
=IIF(
Fields!Mes.Value = 1,
0,
(Sum(Fields!Diferencia.Value)/
ReportItems!Diferencia.Value)
)
But as you may have noticed, it always returns 100% because Sum (Fields! Difference.Value) = ReportItems! Difference.Value) (who would have said it)
I already tried with Fields! Difference.Value & Sum (Fields! Difference.Value, "Information") (the latter is that I get to search for Difference in the Datasets category) But with none of the 3 I can take out the reference as necessary.
Do you have any idea how to achieve this?
Thanks in advance.