Total Value in Pivot Table.

[varunvarma]

Dear All,

Greetings for the day.

Please support with below requirement. Please find attachments for the requirement. I want to calculate the logic explained in QVW. Thanks in advance.

[giakoum]

step 1

dimension : DIMYEAR

expression :

Sum(

  aggr(

  round(

  ((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))/

  Count(DISTINCT [VIN No]))

  )

  ,DIMYEAR,Series)

)

[Anonymous · Accepted solution]

See this:

= if(Dimensionality()>0 or DIMYEAR=2006,
sum(aggr(
round((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))
/
Count(DISTINCT [VIN No]))
,DIMYEAR,Series))
,
sum(aggr(
round((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))
/
Count(DISTINCT [VIN No]))
,DIMYEAR,Series))
-
before(sum(aggr(
round((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))
/
Count(DISTINCT [VIN No]))
,DIMYEAR,Series)))
)

[Anonymous]

attached

[varunvarma]

Thank you sir. I got it.

[varunvarma]

Thank you sir