May 26 2020 03:23 PM
Hello,
I've created a schedule by store but need to make a schedule by company. How do I do this? Is there a formula or trick I can use? I've attached my example data. How do I make a schedule for each company showing what time they are with each store?
May 26 2020 10:05 PM
SolutionHello @khardie8 ,
Let me know if this works for you, please mark as better response if it fits your expectations.
Regards,
karchavez
May 27 2020 07:42 AM
@karchavez thanks! One question though... how did you get the stores to expand to the next column, rather than under the time?
May 27 2020 08:43 AM
Hi @khardie8 ,
Thank you very much for accept as a Best Response!
Click inside your Pivot Table>Pivot Table options>Design>Report Layout>Show in tabular form
(Image attached)
Regards!
karchavez
May 26 2020 10:05 PM
SolutionHello @khardie8 ,
Let me know if this works for you, please mark as better response if it fits your expectations.
Regards,
karchavez