Removing ValueList ?

[#1]

Hi All,

I need some help in removing the ValueList from chart dimension and as well from expression in Case 2 like in Case 1.

Please find the sample attachment for your reference.

Thanks in advance..

Regards ,

Ravikumar

[Gysbert_Wassenaar]

Use Month as dimension and this expression:

=

pick(match(Month,vPrevMonth,vCurrMonth),

  Sum({<Month={"$(vPrevMonth)"}>}Sales)/4,

  Sum({<Month={"$(vCurrMonth)"}>}Sales)/10

)

[#3]

Hi Wassenaar,

Actually I am doing this change to improve the performance.

Your solution is also looking similar to ValueList.Will it effective than using ValueList ?

Regards ,

Ravikumar

[Gysbert_Wassenaar]

I think so. Test it to make sure.... as always 🙂