I have a custom list of about 200 entries, which has three columns (name, mm/dd/yy, $amount). I would like to be able to view a summary of the total amount by month, either in a Chart web part or a custom view, but I can't seem to be able to.

    A, 01/01/12, $50
    B, 01/07/12, $50
    C, 01/21/12, $50
    D, 02/01/12, $50
    E, 02/02/12, $50
    F, 02/03/12, $50

This would yield a bar chart with two columns [Jan $150] and [Feb $150]

Can anyone suggest a method please?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.