Creating a goals spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1642359%22%20slang%3D%22en-US%22%3ECreating%20a%20goals%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1642359%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20on%20a%20spreadsheet%20and%20its%20just%20not%20working%20the%20way%20I%20want%20it%20to.%3C%2FP%3E%3CP%3EWhat%20I%20am%20trying%20to%20achieve%20is%20a%20evolving%20sales%20goal%20for%20a%20week.%3C%2FP%3E%3CP%3EExample%3A%20On%20Monday%20I'm%20putting%20a%20goal%20of%202.%20On%20Tues%20I%20have%20a%20goal%20of%201%2C%20Weds%20a%20goal%20of%203%20and%20so%20on%20and%20so%20on.%3C%2FP%3E%3CP%3EIf%20I%20hit%20my%20goal%20or%20go%20past%20it%20I%20want%20the%20goal%20on%20Tues%20to%20stay%20the%20same.%26nbsp%3B%20If%20I%20miss%20my%20goal%20on%20Monday%20and%20achieve%20only%201%20item%20I%20want%20Tues%20goal%20to%20go%20up%20by%20one.%20So%20Tues%20would%20now%20be%202.%20If%20on%20Tues%20I%20achieve%20no%20items%20my%20Weds%20Goal%20would%20go%20up%20by%202%20and%20so%20on%20and%20so%20on.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help%20me!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1642359%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1642385%22%20slang%3D%22es-ES%22%3ERE%3A%20Creating%20a%20goals%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1642385%22%20slang%3D%22es-ES%22%3EHello%2C%20good%20afternoon!!%20Do%20I%20have%20a%20question%3F%20how%20I%20can%20group%20multiple%20columns%20into%20a%20single%20one%20with%20filters%20in%20pivot%20tables%2C%20such%20as%20the%20example%20that%20Excel%20gives%20in%20the%20introduction%3A%20Where%20the%20columns%20%22food-gifts-music-sports-tickets%22%20are%20grouped%20into%20type%20(Type)%3C%2FLINGO-BODY%3E
New Contributor

Greetings,

 

I'm working on a spreadsheet and its just not working the way I want it to.

What I am trying to achieve is a evolving sales goal for a week.

Example: On Monday I'm putting a goal of 2. On Tues I have a goal of 1, Weds a goal of 3 and so on and so on.

If I hit my goal or go past it I want the goal on Tues to stay the same.  If I miss my goal on Monday and achieve only 1 item I want Tues goal to go up by one. So Tues would now be 2. If on Tues I achieve no items my Weds Goal would go up by 2 and so on and so on. 

 

Can someone please help me!

 

Thank you so much.

2 Replies
Hola , buenas tardes!! Tengo una duda? como puedo agrupar varias columnas en una sola con filtros en las tablas dinámicas, como el ejemplo que da Excel en la introducción: Donde las columnas "comida-regalos-música-deportes-tickets" son agrupados en tipo (Type)
Greetings Hylmar,

I think you posted in the wrong area.