I have a report where I am trying to complete a Monthly / YTD Sales Figures by Calender Year.
I have managed to get my RunningValue function working fine per month, however I would like to apply the same to my 'Totals'
Each Month I would like to Cumulatively Add my Totals but because you cannot nest an aggregate function within another I'm stuck can anyone shed some light on this for me please.
Here is a screenshot of my table as it stands.
YTDPrem is the following Expression:
We can use custom code to achieve this requirement. The sample code would like:
Dim public nettotal as Double
Public Function Getvalue (ByVal subtotal AS Double) AS Double
nettotal = nettotal+ subtotal
Public Function Totalvalue()
Then you can use the expression below in the text-box.
If you have any questions, please feel free to ask.
TechNet Community Support
I used your code and then the =Code.Getvalue(Fields!Premium.Value) line in my table like so:
It only returned the data like:
Surely it should be the sum of the Year To Date column rather than just the top line?
Forgive my stupidity.