Log In
Register
Home
How to use a horizontal data table with date headers to pivot table
KENNETH BATILO
Member
Members
Forum Posts: 32
Member Since:
January 30, 2020
January 30, 2020
Offline1
February 3, 2023 - 4:11 am
Hello all,
To get to the point
This is the data
I ultimately want to make a pivot chart with slicers so that I can create an interactive dashboard that can filter by group (and possibly date range).
I would also like the date to be dynamic as the range will increase in columns each day.
Thank you all so much in advance!
Mynda Treacy
Admin
Forum Posts: 4771
Member Since:
July 16, 2010
July 16, 2010
Offline2
February 3, 2023 - 10:10 am
Hi Kenneth,
You can use Power Query to unpivot (https://www.myonlinetraininghu.....-scenarios) the first table, and then use PivotTables and Slicers (https://www.myonlinetraininghu.....o-tutorial) to summarise and filter the data according the second and third tables in your screenshot.
If you get stuck, please provide the Excel file you used to create the screenshots and we can help you further.
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Charles Johnson
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 339
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Drew Smith
Michael Denton
Nick Pascal
David Webb
Johannes Bruentrup
John Jay
Larry Silverman
David Rousseau
Melinda Heidemann
Jose Fuentes
Forum Stats:
Groups: 3
Forums: 25
Topics: 7073
Posts: 30998
Member Stats:
Guest Posters: 49
Members: 34470
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —