Selections

[sunilkumarqv]

     If i select ID 2 its show only that value

i want it to present 1 and 2

[Sokkorn · Accepted solution]

Hi Sunil,

Change your expression from Sum(value) to Sum({$<ID ={"<=$(=Max(ID))"}>} value)

Regards,

Sokkorn

[#3]

hi sunil,

please find attachment

[MK_QSL]

Change your expression as below..

sum({<ID = {'<=$(=Max(ID))'}>}value)

[ashwanin]

Change the expression sum (value) to Sum({$<ID ={"<=$(=Max(ID))"}>} value) in the pivot.

You will get the result.

[#6]

i think all these all Solutions have Given u desire result

so u can mark this question as answered

[sunilkumarqv]

Thanks for valuable contrubution but I link some tricky dynamic MonthendID Dates Please do it that with expression what ever you want

whatever i created dynamically MonthEnID  should be used as demension .So here i am getting only related data want it to be all monthends.It work in same manner before what you guys are posted

[MK_QSL]

Confused... Can you let us know what is the desired output you want.

Your question is unclear.

[#9]

????

[sunilkumarqv]

On using dynamic Dates as Dimension in want t od o as of test file