Post reply

Filter -Sum Total

  • February 25, 2009 at 11:18 pm

    #384020

    Does anyone know how to add total and/or subtotal for each colum in a table based on a filtering criteria?

    I have the following fields in a table. I would like to sum each column and enter a total for all fields: I do not want to sum all of the data in the dataset, Howevrr, I would like to sum all th fields if Divisioname = "Gas".

    Electric Usage Gas Usage Unit Price

    5.000 3.000 7.71

    5.000 3.000 7.71

    5.000 3.000 7.71

    Total

    I would appreciate any help on this issue.

    leonie6214

  • February 26, 2009 at 12:52 am

    #950442

    Hi...frend..:)

    I hope..this may help u...

    Suppose u have fields...such as Electric Usage, Gas Usage, and Unit Price..Now..u want to calculate the sum.

    So...you may try this infront on Total Field;

    =Sum(Fields!ElectricUsage.Value)

    =Sum(Fields!GasUsage.Value)

    =Sum(Fields!UnitPrice.Value)

    Thanks alot,

    Niraj

  • February 26, 2009 at 7:43 am

    #950597

    Thanks Niraj,

    The problem is that all the values in these fields are summing up. I need to be able to filter the fields by DivisionName.

    How would I filter all of these fields if DivisionName = "Gas"?

    Any other suggestion would we greatly appreciated.

    Thanks

  • February 26, 2009 at 1:24 pm

    #950815

    Did you try grouping on divsionname?You can apply filters at group level if you wanted.

  • February 26, 2009 at 3:04 pm

    #950860

    I tried grouping on division name and I am still getting the value for the entire field (Gas_Usage) instead of the value based on the filter criteria: DivisionName = "Gas".

  • February 26, 2009 at 3:14 pm

    #950867

    Did you try matrix report?

  • February 26, 2009 at 9:14 pm

    #950968

    I have never tried matrix report. I am not sure if it would be appropriate for this report, but I will give it a shot.

    thx

  • February 27, 2009 at 7:27 am

    #951158

    Found this, hopefully this is what you are looking for

    http://www.experts-exchange.com/Database/Reporting_/Q_22901578.html

Viewing 8 posts - 1 through 7 (of 7 total)

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