Count Total Error

[upaliwije]

I have this issue with my Pivot table

In my following screen shot Total Nos is 12 where as actual Nos should be 4 as can bee seen in 3rd screen shot. In 2nd screen shot Nos shown as 12

My Dimension & Expression   are shown below

What could be reason for the error. Pls correct where I am wrong

[upaliwije]

On the further I noticed that since I have 3 items in the Value List count is taken 3 times

[Chanty4u]

try this

vMaxYear=max(riskyear)-1;

only change the set exp

,sum({<risk_year={$(vMaxYear)}>Nnos)

[Anil_Babu_Samineni]

May be use

Sum({<RISK_YEAR = {"$(=AddYears(Max(RISK_YEAR), -1))"}>} Nnos)