Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How create relationship between budget sheet and Sales table

Hi All,   I have problem creating relationship between budget and sales table   1. I have budget in Excel workbook, Consists of Monthly and weekly budget 2. Need to compare monthly and weekly b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Phil_Seamark,

 

 

I dont have Date coloumn in my budget table, It's monthly budget.

 

 

Thanks

Mazhar

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Is your [Calendar Month] column a date field?  I understand your budgets are set monthly, but if you have a date value that is the 1st of every month, you will still be able to create useful reports

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Phil_Seamark,

     

     

    Calender Month coloumn is set as Whole Number .

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      HI Anonymous

       

      Can you add a date column to that table?

       

      How big is your data file?  If you share it to me privately I can tidy it up if you like

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Phil_Seamark,

         

        You want to me add Date coloumn to Budget Table???. Date table already have Date coloumn. How can I Share file with you?

         

        Thanks.