SOLVED

Make sub schedules from a large schedule

Copper Contributor

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?

3 Replies
best response confirmed by khardie8 (Copper Contributor)
Solution

Hello @khardie8 ,

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

 

karchavez_0-1590555343296.png

Regards,

karchavez

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

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

 
 
1 best response

Accepted Solutions
best response confirmed by khardie8 (Copper Contributor)
Solution

Hello @khardie8 ,

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

 

karchavez_0-1590555343296.png

Regards,

karchavez

View solution in original post