Variables within a formula

[Anahita]

Hi

I want to show sales in a time interval. For this, I have 2 input date which user should fill those. ( VStartdate, VEnddate). Then, in a table or heat map sales should be displayed based on parentID(row) and BGId(column), sales((VcurrentRevenue-VPrevRevenue)/VPrevRevenue)*100 (measure)

VcurrentRevenue: sum({FactRevenueOpDate={“>=$(=VStartDate)<=$(=VEndDate)”}>}RevenueAmt)/100000

VPervRevenue:

sum({<FactRevenueOpDate={“>=$(=VPrevStartDate)<=$(=VPervEndDate)”}>}RevenueAmt)/10000

VPervStartDate: left(VStartDate,4)-1&right(VStartDate,4)

VPervEndDate:

left(VEndDate,4)-1&right(VEndDate,4)

when user choose date and parentID, amount of sales should be calculated for all BGId separately.

sample table that I want to show in the end, is attached. 

[Anahita]

Sample data is here