Excel - Filter a PivotTable with a Timeline

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ก.ย. 2024

ความคิดเห็น • 21

  • @nathanielbalmes6597
    @nathanielbalmes6597 6 หลายเดือนก่อน +2

    Thank you, Chris! This is great learning!

  • @roywilson9580
    @roywilson9580 ปีที่แล้ว +1

    Thanks for the video. I love timelines they are so useful.

  • @onyebuchiogbogu7254
    @onyebuchiogbogu7254 ปีที่แล้ว +1

    Thank you, Chris. I was taught this but it was not so clear but you just clarified it for me.

  • @jeffmueller9422
    @jeffmueller9422 ปีที่แล้ว +1

    Chris, love the videos, my friend! Keep them coming. My first time seeing the timeline feature. Really cool! Thanks!

  • @peanutheed
    @peanutheed ปีที่แล้ว +1

    Perfect. Exactly what I was looking for. Massive help! thanks!

  • @abhishekbhushan1052
    @abhishekbhushan1052 ปีที่แล้ว +1

    Sir, Please guide me that how to use time line for financial year April to March?

  • @user-uy1sl4sk3f
    @user-uy1sl4sk3f 6 หลายเดือนก่อน

    Thanks!

  • @Graphicious
    @Graphicious ปีที่แล้ว +1

    Awesome feature. Do you know if it's possible to select two ranges that are not adjacent? Say, comparing Q1 and Q3 or two years that are one or more years apart.

    • @enuffalready1313
      @enuffalready1313 ปีที่แล้ว

      Or the same quarter, or month, but different years so that you can do a year over
      year comparison...

    • @TerryStoa
      @TerryStoa ปีที่แล้ว

      Very nice. I’ve just recently learned the pivot table basics, and this is new to me.

  • @bundlesbysnowie3105
    @bundlesbysnowie3105 ปีที่แล้ว

    Thanks Chris! Do you have a tutorial on creating a drop down list from Pivot Tables?

  • @johnathanbooth7631
    @johnathanbooth7631 9 หลายเดือนก่อน

    Chris, I'm new to this thanks. Was looking for information on how I can present data in a timeline, not through a timeline filter. Could you help me with this? I have 2 columns, date column, and a description column (which summarises the information released). How could I best use excel to present this data?

  • @popflaviu153
    @popflaviu153 ปีที่แล้ว +1

    Thanks for that. But i have a question. How can i do if i want to select 3 different months (eg february, may and june)? Thanks again for your answer to my question. P.s. soryy but my english is not acurate.

    • @ChrisMenardTraining
      @ChrisMenardTraining  ปีที่แล้ว

      You can use a Filter for that. The Timeline will not let you do that.

    • @popflaviu153
      @popflaviu153 ปีที่แล้ว

      Thank you

  • @Sandipchhetri-zh9ck
    @Sandipchhetri-zh9ck 8 หลายเดือนก่อน

    my question is how do i see sales of two months or years which are not in sucession say for exapmle jan and march or 2023 and 2026 how do i select both plss reply

  • @katesims8816
    @katesims8816 ปีที่แล้ว

    Cool feature but the timeline is too limited (can't include the information ON the timeline itself). Thx!