• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table- Seperated Filters

K

KH

New Member
Hi,


I want to create a pivot table report that will track performance 'Year to Date'. I'm having difficulty is selecting the relevant periods. For example Period 1 has 4 weeks, Period 2 has 5 weeks etc. I'm currently 3 weeks into Period 2. I want to be able to Select Period 1 week 1,2,3,4 and Period 2 week 1,2,3. The Pivot Table filter won't allow me to do this. Is there a way around this?


Many Thanks


Yr 2012

Period (Multiple Items)

Wk (Multiple Items)


Row Labels % of Budget Achieved

Shop A 54.16

Grand Total 54.16
 
Good day KH


I would look at grouping, not quite sure of you needs ,you say the first period has four weeks the second five weeks and so on, do you mean the sixth period would have nine weeks and the seventh period would have ten weeks? or are there a fixed number of periods with variable weeks lengths


If you can upload a sample to Dropbox it would help.
 
Hi bobhc,


The accounting period runs from September to August, the majority of the 12 periods have 4 weeks and some will have 5 weeks.

I'm using 'Period' and 'Week' to filter my data.

I'm able to select the relevant periods from the 'Period' dropdown (no issue there).

However selecting the number of weeks is a problem. The 'Week' dropdown doesn't allow me to select together say Period 1 - Week 1,2,3,4 and Period 2 - Week 1,2.


The reason I need to exclude Weeks 3 and 4 in Period 2 is that I have budget figures build into my database, I don't want to include these as there is actual performance yet.
 
Hi KH,


I think it is possible to define periods in a separate table and then look-up corresponding periods for the data in terms of week and add that column to your PT so that you can look for certain period?? Does that sound appealing??


Regards,
 
Hi Faseeh,


For Period 1, weeks 1 to 4. The combined % of budget achieved for the 3 shops is 55.16%. If I were to create a seperate Pivot table for Period 2, weeks 1 to 2, how would I correctly combine this two weeks Grand Total with the previous 4 weeks Grand Total.


Thanks


Yr 12/13

Period 1

Wk 1 TO 4


Row Labels % of Budget achieved

SHOP A 62.65

SHOP B 66.58

SHOP C 39.21

Grand Total 55.16
 
You must log in or register to reply here.
Back
Top