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 ...
Need Help
Show and Tell
tips and tricks
karchavez's avatar
karchavez
Brass Contributor
May 27, 2020

Hello khardie8 ,

Let me know if this works for you, please mark as better response if it fits your expectations.

 

Regards,

karchavez

  • 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