SSRS Report Group Total

Question

I am trying to make a report in SSRS with Data source CUBE. I have a column which is calculated and inside the group. I could not take group total for that item. Please any guide my calculated column expression is

=(Fields!Count_of_Passengers.Value/Sum(Fields!Count_of_Passengers.Value,

"LHSH"))*100

 

Answer 1

Hi Use like the following =Sum(Fields!Count_of_Passengers.Value/Sum(Fields!Count_of_Passengers.Value, "LHSH"))*100),"YourGroupName")

Answer 2

Thanks for reply.

The following error occured when i am trying your solution.

'Aggregate functions cannot be nested inside other aggregate functions'

Answer 3

try adding the same expession in a seperate field in the datasets tab.

ex:

create a new field 'group total '

group total expression =(Fields!Count_of_Passengers.Value/Sum(Fields!Count_of_Passengers.Value,

 

"LHSH"))*100

and wherever u want try placing the group total field.

Answer 4

Just give a try to this expression

=(Sum(Fields!Count_of_Passengers.Value)/Sum(Fields!Count_of_Passengers.Value,"LHSH"))*100

Hope its helpful....

---

Pavan Kokkula Infosys Technologies Limited.

Answer 5

Thanks, its great. It solved my problem.

Answer 6

Hi goldenagent,

If the reply helped you, could you please mark it as answer? then other communities will get the direction when encounter the same issue. This is also a little reward to the forum supporter. Thanks.

Regards,

Challen Fu