Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table of 4 columns, Date, Parameters, changes and dash_count. all are dimensions. This table is filtering when i select Parameters from another table but i want to show data of all parameters in this table ignoring the selection made in Parameters. i am trying to add {<Parameters=>} . but it is not giving result as all fields are dimensions. How can i solve this?
Any suggestion would be helpful.
Thank you.
Hi @VaishnaviMogal2 ,
Use the Set modifier =1, something like this :
sum({1<Parameters>}exp)
Regards,
Rohan.
@Rohan Thanks for reply but as I mentioned all fields are dimensions in table so I can't use SUM(expr)
Hi @VaishnaviMogal2 ,
I meant in that table, there must be some measure right ? If not. then simply apply an alternate state to that table, the selections won't impact the given table.
Regards,
Rohan.
which would be the better solution
1.using Alternate state
2. creating measure, adding this set exp and hiding this measure(by giving text color white)
I would prefer 2 because it'll be easy for my maintainance & understanding. But if the user is downloading the table then will you be ok with the measure being shown there ?
Regards,
Rohan.