Forum Discussion

slyfox's avatar
slyfox
Icon for Helper II rankHelper II
8 years ago

Measures vs budget

Hello,

 

Looking for the solution how to add two additional columns at the end of my table with information about target budget value and % btw month sum and budget value

 

 

 

In Excel budget table looks folowing

 

   Measures -> KPI's
   
D_DateD_MachineD_CrewNet productionNet production (sheet)m2 per sheetSet-up time per order
Jan-18Machine 1Crew 1340210060002
Jan-18Machine 1Crew 2350250032002
Jan-18Machine 1Crew 3320230062003
Jan-18Machine 1Crew 4330260032002
Jan-18Machine 2Crew 1340210060002
Jan-18Machine 2Crew 2350250032002
Jan-18Machine 2Crew 3320230062003
Jan-18Machine 2Crew 4330260032002

 

Each tab of my report related to specific production machine

Each machine has own crews

Each crew has a month budget for the listed measures in my table

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    slyfox,

    Could you please post expected result based on the above sample data?

    Regards,
    Lydia