
Alex Meins
Active Member
Members

Forum Posts: 5
Member Since:
May 25, 2021
May 25, 2021

Hello,
i just created a smart table and used colums, one for month and one for year.
Problem is, that now the pivot table is not recognizing the month entries as "dates" as they are words and excel doesn't know which date that is.
What can i do, to keep the convenient level data input for my key users as they dont want to type in a specific date but just the month and the year per line, but also use timeline slicers for my dashboard.
Would it work with a helper column?
Thank you very much,
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, John Kobiela, Malcolm Sawyer
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793
Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
