Forum Discussion

David_Jaffe's avatar
David_Jaffe
Copper Contributor
Sep 07, 2020

Creating a goals spreadsheet

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.

excel

2 Replies

  • Hylmar's avatar
    Hylmar
    Copper Contributor
    Sep 07, 2020
    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)
    • David_Jaffe's avatar
      David_Jaffe
      Copper Contributor
      Sep 07, 2020
      Greetings Hylmar,

      I think you posted in the wrong area.

Resources