Block further filtering in data table

[advan7]

Hi,

I'm just new to cliksense and making my first simple app. I'm searching an option to block ALL further filtering of columns/rows in the created table (so this example beneath may not occur anymore). I searched for it but i didn't found anything simple to block this. 

[vunguyenq89 · Accepted solution]

Hi,

You can add Set Analysis to your measure, with {1} being the set identifier. This will override all user selections and always apply the whole data model to the table. 

For example, assume that your table has one measure column =Sum(Sales). You can rewrite it as =Sum({1} Sales).

Hope this helps.

BR,

Vu Nguyen