creating a line that is not relevant to dimension.

[#1]

I want to create a reference line and I know that I can do it in a properties - reference lines. but if I do that I cannot use Date dimension. I want my reference line to be affected by date dimension but not other dimension. because the reference is affected by time.

but if I try to use reference line in order to create the line, i am not able to make it affected by date dimension.

and if I try to use expression to create the line I cannot make it not affected by other dimension than date dimension.

How should I do this?

Thank you!

[phaneendra_kunc]

Perhaps a sample apps will be nice to have.

Your request is simple, but dont understand where you are facing the challenge. If you can write a set analysis statement for your reference line where it should change just by time only and not by any other then it should work .

Try this

Sum({1<DateDim=$::DateDim>} Sales)

Or

sum({$<[$(=Concat({1<$Field-={'DateDim'}>}distinct $Field,']=,[')&']=')>} Sales)