Pivot table

Discussion in 'Excel' started by Narayanan m s, Aug 3, 2017.

  1. Narayanan m s

    Narayanan m s

    Joined:
    Jun 8, 2017
    Messages:
    2
    Likes Received:
    0
    dear all
    I have created an expense statement.
    This has fields date, nature of expenses.
    I want to construct a pivot table summarising total for each account by months as below:
    Nature of. Apr. May. June
    Expense

    Rent. 400. 500. 500
    Food. 80. 60. 100

    How this can organised?
    The file is for the year not for each month.

    m s narayanan
     
    Narayanan m s, Aug 3, 2017
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.