SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline
Hi Diana
I am using Excel 2010 and this should also work in Excel 2013.
You can refer to the attachment for one way to do what you wanted.
I have created a Due Day field to get the Day portion from the Date.
I have also grouped the Date field by Days, Months and Years.
This will allow you to create the 3 slicers you wanted.
Please note that the day/month/year will only appear in the slicer if they are available in the data. i.e. if the date 31st does not exist in the data, it will not appear in the Due Day slicer etc.
Hope this helps.
Cheers
Sunny
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: marco tortora, Kang-Ting Lee, Daniel Robertson, MacNaughton Finance, Amanda Zibell
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30158
Member Stats:
Guest Posters: 49
Members: 33702
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —