Excel Forum

Filter from Pivot table

Lakshmipathi Ganesan

Member

Members

Forum Posts: 18

Member Since:
November 26, 2020

Offline

January 4, 2021 - 3:42 pm

I have a pivot table with multiple years till December 2020 data. I want to filter for the period April to December for the years 2019 & 2020 and I tried filtering the date as per the screen shot attached. This is filtering only for one year. How do I filter for 2020 also?

Thanks

G. Lakshmipathi

Lakshmipathi Ganesan

Member

Members

Forum Posts: 18

Member Since:
November 26, 2020

Offline

January 4, 2021 - 4:06 pm

I am able to filter that also

Thanks

G. Lakshmipathi

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1810

Member Since:
November 8, 2013

Offline

January 4, 2021 - 5:07 pm

glad to hear you managed to make it work

Cheers

Catalin

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Kim Knox, Bhuwan Devkota

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 204

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Jefferson Granemann

Glen Coulthard

Nikki Fox

Rachele Dickie

Raj Mattoo

Mark Luke

terimeri dooriyan

Forum Stats:

Groups: 3

Forums: 24

Topics: 6221

Posts: 27285

Member Stats:

Guest Posters: 49

Members: 31909

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen