Using previous values in Straight table-Where first value is "Hardcoded"

[Pulkit_Thukral]

Hi All,

i am developing below table:

Expression -Capacity Baseline -Storage has july month values hard-coded(manually inputted).Now,from the next month("Aug") ,value should be calculated as followed:-

Capacity Baseline -Storage Value of Current Month = Capacity baseline storage of previous month + BAU of previous month +SCR of previous month+ Limewood of previous month+reclaim of previous month.

Example- Aug month should have Capacity Baseline Storage value as 1101 under VSP and 184 under HUS.

All the above mentioned Names are Expressions with below logic:-

BAU = COUNT({<[Change type*]={'Allocation'},[BAU/SCR/Project]={'BAU'}>}[Volume (in GB)*])

SCR = COUNT({<[Change type*]={'Allocation'},[BAU/SCR/Project]={'SCR'}>}[Volume (in GB)*])

RECLAIM = COUNT({<[Change type*]-={'Allocation'}>}[Volume (in GB)*])

How can this be achieved.

[sunny_talwar]

Would you be able to share a sample to look at this?

[Pulkit_Thukral]

					20-Jul-16

Storage system*	Change type*	BAU/SCR/Project	Volume (in GB)*	Implementation date*
VSP	Allocation	BAU	300	5-Jul-16
VSP	Allocation	BAU	500	6-Jul-16
VSP	Allocation	BAU	515	6-Jul-16
VSP	Allocation	BAU	40	11-Jul-16
VSP	Allocation	SCR	980	14-Jul-16
VSP	Reclaimation	SCR	500	18-Jul-16
VSP	Reclaimation	BAU	10	18-Jul-16
HUS	Allocation	BAU	20	19-Jul-16
HUS	Allocation	BAU	450	19-Jul-16
HUS	Reclaimation	Iscr	250	20-Jul-16
HUS	Reclaimation	SCR	240	20-Jul-16

[Pulkit_Thukral]

Were you able to try with the sample data Sunny ?

[Pulkit_Thukral]

i was able to solve this with the help of above function.Thanks