Forum Discussion

edavila's avatar
edavila
Icon for Helper II rankHelper II
9 years ago

Amounts not showing Correctly

I have 2 tables one that has all the dates from 2 years listed and also the name of the month, week and year   and I create a report as table to show the Balance sheet for the company at a certain ...
Need Help
Show and Tell
parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

I looked at your sheet, and you renamed amount to amounr 2016 and amount 2017 respectively, just don't rename those columns, leave it as amount and then use append query.

 

basically what you want is FY 2016 is append to FY 2017 (or vice versa) and all the rows are appended to existing table and not added as extra column, 

  • edavila's avatar
    edavila
    Icon for Helper II rankHelper II
    9 years ago

    I was able to put amount on the 2016 -2017 but the cash graph is not working

     

    thanks