Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If i select ID 2 its show only that value
i want it to present 1 and 2
Hi Sunil,
Change your expression from Sum(value) to Sum({$<ID ={"<=$(=Max(ID))"}>} value)
Regards,
Sokkorn
Hi Sunil,
Change your expression from Sum(value) to Sum({$<ID ={"<=$(=Max(ID))"}>} value)
Regards,
Sokkorn
hi sunil,
please find attachment
Change your expression as below..
sum({<ID = {'<=$(=Max(ID))'}>}value)
Change the expression sum (value) to Sum({$<ID ={"<=$(=Max(ID))"}>} value) in the pivot.
You will get the result.
i think all these all Solutions have Given u desire result
so u can mark this question as answered
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
Confused... Can you let us know what is the desired output you want.
Your question is unclear.
????
On using dynamic Dates as Dimension in want t od o as of test file