Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As i mentioned in the subject, i want disable the first dimension in my table from selecting a filter.
The table and the disabled dimension is like this
The reason I wanted to disable it because I use "Above" formula in O/B and Outstanding column.
Is there any solution ?
2 ways :
1) The hard way : you change your above expression to not change no matter so selection : a combo of aggr and {1}
2) You create ur date field as a measure not a dimension : aggr(only(date),date) => no filter possible
sorry for late response,
for the first solution,
How do I change my code, is it like this
=Sum(InVal) to =Sum({1}aggr(InVal))
for the second solution,
the result is still the same. The table still changed