I have three fields like below table for year 2010-11
Projects
Opening Stock
Closing Stock
Month
A
100
120
Apr
A
120
160
May
A
160
200
Jun
A
200
210
Jul
A
210
230
Aug
A
230
280
Sep
A
280
300
Oct
A
300
350
Nov
A
350
360
Dec
A
360
390
Jan
A
390
400
Feb
A
400
500
Mar
my requirement is to find Total Opening Stock for the Year and Closing stock cumulative for all projects. There are three projects A,B and C. the table only showing A.There are data available for B and C in the same format. Does anyone has any Idea how to solve this query.
You may have to attach data sample for expert advice from anybody.
However, Please check data model preview and see whether you have uploaded data for B and C. If you have supressed null values in Dim, you normaly get this situation.
