• 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.

Search results

  1. K

    Pivot Table- Seperated Filters

    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...
  2. K

    Pivot Table- Seperated Filters

    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...
  3. K

    Pivot Table- Seperated Filters

    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...
Back
Top