darknessfall5
New Member
- Joined
- Feb 16, 2017
- Messages
- 9
Good day im trying to make a dashboard for the cash in bank of the company and the balance sheet also
I run into a problem and I just can seem to figure it out
this 2 tables are connected thru another table named date were I have all the dates on both years 2016 amd 2017, the problem that I have is when Im bringing the cash into a graph to show the end balance of the month is just giving me the last day of the month instead os adding everything and I think that the problem is that is a not a measure and here is my big problem I'm looking to see if there a formula for vlookup or sumif that will just bring a certain part on the colum and added as an example is I will like to make a new column or measure and just bring all cash in bank from that column instead of adding all the column.
I hope that is some how clear
https://www.dropbox.com/s/w0q8kiz48zmm4nq/Capture.PNG?dl=0
<tbody>
</tbody>
<tbody>
</tbody>
I run into a problem and I just can seem to figure it out
this 2 tables are connected thru another table named date were I have all the dates on both years 2016 amd 2017, the problem that I have is when Im bringing the cash into a graph to show the end balance of the month is just giving me the last day of the month instead os adding everything and I think that the problem is that is a not a measure and here is my big problem I'm looking to see if there a formula for vlookup or sumif that will just bring a certain part on the colum and added as an example is I will like to make a new column or measure and just bring all cash in bank from that column instead of adding all the column.
I hope that is some how clear
Account | Posting Date | Amount | Reference | |
401500 | 1/1/2017 | 100 | ||
610010 | 1/1/2017 | 100 | ||
102000 | 1/1/2017 | 100 | ||
20000 | 1/1/2017 | 1000 |
<tbody>
</tbody>
Gl Account | Mapping statement | location | type of account | |
610010 | P&L | 6 | Expense | |
401500 | P&L | 4 | Revenue | |
400000 | P&L | 4 | Revenue | |
501000 | P&L | 5 | COGS | |
102000 | BS | 1 | Asset | |
200000 | BS | 2 | Liabilities |
<tbody>
</tbody>