Forum Discussion

khardie8's avatar
khardie8
Copper Contributor
May 26, 2020
Solved

Make sub schedules from a large schedule

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?

Need Help
Show and Tell
tips and tricks

3 Replies

    • khardie8's avatar
      khardie8
      Copper Contributor
      May 27, 2020

      karchavez thanks! One question though... how did you get the stores to expand to the next column, rather than under the time?

      • karchavez's avatar
        karchavez
        Brass Contributor
        May 27, 2020

        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

         
         

Resources