Post reply

How to add a total in a column on a table ???

  • July 31, 2013 at 10:19 am

    #275836

    +-------------+-----------+-------------+--------+

    |Supplier | Agent | Amount | Total |

    +------------ +------- -- +--------------+-------+

    | | A10051 | 237.2 | |

    |S2005068 +-----------+------------- + |

    | |A10052 | 23.8 | |

    +-------------+------- ----+-------------+--------|

    Hi experts

    How are U??

    I need to display Total rows of "Supplier" in the right columns

    I tried the "add total" but SSRS create me the column near the right or the left of the "Supplier column"

    Do U have any idea ??

    Thank U

  • August 1, 2013 at 2:52 am

    #1637686

    Nothing ??? 🙁

  • August 1, 2013 at 9:34 pm

    #1638039

    I can't help in SSRS but, as a sort of "bump" for you, what kind of total are you looking for?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 2, 2013 at 1:23 pm

    #1638329

    Can you clarify your question a little more. Are you looking for a running total, the total for the row, or the column total. You did say supplier total, are you wanting to count number of supplier or the amount? If I can picture your example correctly, I see four columns but cannot picture what right or left supplier column are you talking about? Do you simply want to insert a new column? Please provide specifics, and I am sure lot of us here can provide assistance.

    Thank you !!

    §§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§

    always Happy, always Prasanna 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

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