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