topic Leave dimension out of a table. in App Development

Leave dimension out of a table.

Nemo1 — Fri, 15 Nov 2024 20:55:20 GMT

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

Re: Leave dimension out of a table.

marcus_sommer — Tue, 09 Jul 2024 08:43:04 GMT

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)

Re: Leave dimension out of a table.

BrunPierre — Tue, 09 Jul 2024 09:22:37 GMT

If you're looking to create a dimension, try this

=Aggr(Only({<Vehicle-={'Vans'}>} Vehicle), Vehicle)

Re: Leave dimension out of a table.

Sayed_Mannan — Tue, 09 Jul 2024 09:39:28 GMT

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.