Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table containing several columns. I want to filter it, but can't add a filter to the filter shelf. So how do I filter this table?
perhaps you need a Calculated Dimension?
Example:
You have a field called Calendar Month that includes each of the months of the year. In your app, you want include a table that shows the sales for each of the first 6 months of the year. For the rest of the months, you want to see a total. You can use an expression to create this calculated dimension.
Syntax:
If ([Calendar Month] <7, [Calendar Month], 'Rest')
perhaps you need a Calculated Dimension?
Example:
You have a field called Calendar Month that includes each of the months of the year. In your app, you want include a table that shows the sales for each of the first 6 months of the year. For the rest of the months, you want to see a total. You can use an expression to create this calculated dimension.
Syntax:
If ([Calendar Month] <7, [Calendar Month], 'Rest')
Thanks, calculated dimension is the way to do it. Shame I can't just put a field on the filter shelf.