• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create a new table to obtain daily target

W

wmf_wmf

New Member
I have a table with monthly targets by branch and category for each month. Is it possible to create a table that includes all the month dates with its daily target by branch and category?



Daily Target = Target / No.of days in that month.



The reason I want it as a table and not a measure is because in my sales data when the agent has not made a sale on 1 day it does not show his daily sale vs daily target. eg. if the agent has not made a sale on 3rd Jan in category A it does not show Daily sale vs target ( 0 vs 26)



The data I have :



MonthBranchCategoryMonthly Target
Jan AXA800
Jan BCB500
FebAXA750
FebBCB550


Desired Output :



DateBranchCategoryDaily Target
01-01-2024AXA26
02-01-2024AXA26
03-01-2024AXA26
04-01-2024AXA26
05-01-2024AXA26
06-01-2024AXA26
07-01-2024AXA26
08-01-2024AXA26
09-01-2024AXA26
10-01-2024AXA26
11-01-2024AXA26
12-01-2024AXA26
13-01-2024AXA26
14-01-2024AXA26
15-01-2024AXA26
16-01-2024AXA26
17-01-2024AXA26
18-01-2024AXA26
19-01-2024AXA26
20-01-2024AXA26
21-01-2024AXA26
22-01-2024AXA26
23-01-2024AXA26
24-01-2024AXA26
25-01-2024AXA26
26-01-2024AXA26
27-01-2024AXA26
28-01-2024AXA26
29-01-2024AXA26
30-01-2024AXA26
31-01-2024AXA26
 
Could you attach a workbook with this in it? It will answer loads of questions and prevent us guessing (wrongly) your setup, and save us a bit of work.
For example, in the Month column, are we talking dates formatted just to show the month or string literals "Jan", Feb" etc.?
 

wmf_wmf​

  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
As You should have read before posting from

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
Those are for You too
 
vletm said:

wmf_wmf​

  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
As You should have read before posting from

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
Those are for You too
Click to expand...
Sure. I will do the needful.
 
You must log in or register to reply here.
Back
Top