Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Currently I have an expression in Straight Table in which I am using IF condition :
> if(campaign=' ' and timescale=' ' , date)
But what is happening is if I make selection in the campaign list box then Staright table report will gone.
So , I have to apply the set analysis so that I can by pass the selections .
What would be the expression for this ?
Thanks
yes i have tried the aggr function but you dimension is only capaign?
please try to explain what you are trying to achieve? because you said you wanted to use only() in the dimension but now you are posting that you are using it in the expression
I have also tried to use aggr(only({ })) in the dimensions but it is not by passing the selections in the list box.
What I want is :
1. apply this in dimensions
2. In the only want to mention a particular campaign and timescale i.e aggr(only(1{<campaign='Name',timescale='name'>}date),date)
3. Want to bypass the selections in the list box.
Thanks