consistency required

[Anonymous]

hi all ,

please  find the attachment where i need to show the consistency of dealers . i only need to show the dealers who performance is 100 or above on a consistent basis . i am not able to avoid null values . if a dealer fails to achieve in a particular month then that dealer should be omitted . continuous achievement is required .

[el_aprendiz111]

Hi,

Would you be able to share a sample with the expected output? (Qvw)

[vishsaggi]

A sample would help us to quickly work on this. However, one way is you have to write a calculated dimension on your dealername with your expression. Like I might be wrong but may be like below

= IF(ISnull(Aggr(yourAchieve%ExpressionHere, Month) <> -1, DealerName)

Then check supress when value is null for this dimension in the dimensions tab.

[Anonymous]

Thanks for the help vishwarath but this is no !t working . let me attach the qvw file in here