First QV App

[Anonymous]

I want to create a simple QV dashboard that has a few parts:

I want to create a simple table that calculates my ending balance ( per month ). See very simple !

Can someone give me some advice to start this?

My Inventory / Demand / Production are individual Excel worksheets that I have already uploaded into QV.

Just not sure on where to begin..

[Anonymous]

Something like this in 1 table:

	Demand by Month
	2016-06	2016-07	2016-08	2016-09	2016-10	2016-11	2016-12
Inventory	5000	4000	3000	2000	1000	0	-1000
Production
Demand	1000	1000	1000	1000	1000	1000	1000
Ending Balance	4000	3000	2000	1000	0	-1000	-2000
MOC	3.00	3.00	3.00	2.00	1.00

[awhitfield]

Hi Alan,

can you upload your QVW and excel source data?

Andy

[Anonymous]

How do I upload a file to the discussion ?

[oknotsen]

Click on reply.

In the reply, go to the top right corner and click on advanced editor.

You will find the attach option at the bottom.

[Anonymous]

I have attached the inventory and demand worksheets.

I have removed any confidential information and left the data.

Column M in Inventory and Column A in Demand would be the primary keys linking them.