Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
So I have a table, and lets say i want to display all kind of vehicles and their characteristics but vans.
How can i leave vans out?
I tried this formula, but it does not work, yeah it leaves vans out of the vehicle columns, but it is still showing me its sales and costs in the sales and costs column. I dont want that. I need it completely out of the analysis.
=If(Vehicle<> 'Vans', Vehicle)
thanks
The most simple way would be the user selects directly which dimension-values should be included respectively excluded - and not to design specialized objects with any hard-filtering.
Beside including any condition in the dimensions you may include it within the expression with something like: sum({< Vehicle -= {'Vans'}>} Value)
If you're looking to create a dimension, try this
=Aggr(Only({<Vehicle-={'Vans'}>} Vehicle), Vehicle)
you can achieve this with set analysis, try this,
SUM({<Vehicle -= {'Vans'}>}Sales)
or you can also do this by using calculated dimension
IF(NOT MATCH (Vehicle, 'Vans'), Vehicle)
If this solve your issue, feel free to mark this as a solution.