Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    May 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need to create a report using the Master data from the Pivot Table

    Hi All,
    I'm new to here and fairly new to VB so any help would be greatly appreciated.

    I have the Master sheet which contains Pivot Table. In the master sheet I need to have t report filter with the current Month. Also I need to select in the colum lable for Current Base type.

    The extract will look like mentioned below.

    Team Category No Name Base Type Grand Total
    Sales International 1 Anna 9 9
    2 Jenny 1 1
    3 Rita 8.09 8.09
    4 Stephen 15 15
    5 Sujan 10.5 10.5
    International Total 43.59 43.59
    India 1 Madhu 27 27
    2 Vinay 14 14
    3 Kavitha 2 2
    India Total 43 43

    My requirement is to get the details in another work sheet.

    Month International India
    Count Total Count Total
    Jan 5 43.59 3 43

    The sheet should be created with this fortmat with Month, And count of each division along with the totals.

    Please help me to proceed on this.

    Regards,

    Vishali S

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a version with proprietary information removed of the what you have and what you want?

    Steve

  3. #3
    New Lounger
    Join Date
    May 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Mr.Steave,

    Thanks for your reply. I have attached my Sample with all information as comment.

    Awaiting for your positive reply.

    Thanks,

    Vishali S
    Attached Files Attached Files

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    To have a field named month, you must have field with the month data in it. I don't see your source data, does it have a month field? [Note Your "pivot table" is a not a pivot table, making it difficult to answer your question about filtering in the tabel...]

    Could you supply a sample source dataset, a sample pivot table, what results you want to have and perhaps elaborate on your questions, specific to the sample so we understand what you want/need?

    Steve

  5. #5
    New Lounger
    Join Date
    May 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Steve,

    The Week No in the Pivot Table will provide me the month in the Report. Only one row will be created for each week. The next week the the next row needs to be appended.

    Hope I am making you clear on the requirement.

    Regards,

    Vishali S

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You can add the weeknum as a pagefield, but it is not the same as the month. You would need to calculate the month from the weeknum.

    Hope I am making you clear on the requirement.
    Perhaps if you could supply a sample source dataset, a sample pivot table, what results you want to have and perhaps elaborate on your questions, specific to the sample you would start in making it clear...

    Steve

  7. #7
    New Lounger
    Join Date
    May 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Steve,

    Thanks for the response. I have attached the source data(Sheet1), Pivot table(Sheet2) and the report actually i need(Sheet3).

    Actually the pivot table will be present in another excel sheet. My report will ask for the week number once provided the macro should open the pivot table excel sheet and obtain the details for me. (Subtotal of Kategorie and the Count value for each Team)


    regards,

    Vishali S
    Attached Files Attached Files

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In the master sheet I need to have t report filter with the current Month.
    From the field list, drag either the calendarmonth or the periodmonth to the Report filter area

    Also I need to select in the colum lable for Current Base type.
    I am not sure what you mean here. It seems to be doing this in the sample If by "Current Base Type", you mean the "Labour Type". The issue is that there is only one value so there is nothing to filter.

    My requirement is to get the details in another work sheet.
    Changing the pivot settings (or creating a new pivot table with the appropriate setup) is possible from the data set you have (I filtered on Team to get the partial list):
    Capture.PNG

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •