LinkedIn
Twitter
I have some data that I'm trying to compare. I need to look at money spent across a series of categories, then be able to look at a money spent at a specific store with that category. The company spend shouldn't be affected by any filters but the store spend will be... depending on which store is selected on the dashboard. So far I've not found a good way to do this.
I've tried using a derived table but the filter still gets applied. I also tried using the can_filter: no option in lookml but that didn't seem to prevent it either. (I guess that prevents it from being USED as a filter). Anyone have any ideas?
