Creating a goals spreadsheet

[David_Jaffe]

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]

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)

[#3]

Greetings Hylmar,

I think you posted in the wrong area.