August 16, 2012 at 7:18 am
=Fields!FICAMWPR.value, "DataSet11"
Is there a way to do this without a sum for a second dataset? When i put sum infornt of this is sum everything.
August 16, 2012 at 7:21 am
Here is a example of what is happening
I have two datasets
lets just say dataset3 and dataset4
When I run this:
=Sum(Fields!S125.Value, "DataSet4")
It gives me the sum of each employee in one total.
This is what I expect to see
employee s125
A 10
B 15
but it shows this:
employee s125
A 25
B 25
and if i look at another employee it would add that one as well. When I take the sum off it doesn't work for the 2nd dataset
August 23, 2012 at 9:37 am
It depends on what attributes you have in your query. It will sum up according to whatever dimension attributes you have put in your query.
First try creating a new dataset and get the values exactly how you want to show up. You might have to create multiple datasets to make it work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply