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

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.
Similar Threads
  1. DanM
    Replies:
    1
    Views:
    434
    XLPadawan
    Jun 13, 2016
  2. Martin Sprenz

    Pivot table Days to Months

    Martin Sprenz, Mar 17, 2015, in forum: Excel
    Replies:
    0
    Views:
    287
    Martin Sprenz
    Mar 17, 2015
  3. tcebob
    Replies:
    4
    Views:
    266
    tcebob
    Nov 22, 2016
  4. NathanielJS
    Replies:
    0
    Views:
    190
    NathanielJS
    May 5, 2017
Loading...