Filter Chart using dimensions only

[Wahab]

Hi all, 

I have this sample dataset from one source.  I want to show in a straight chart, just the Store and Systems columns.  But I want them to be filtered by the dimension Function that has the value of only 'Fixed Ops'.  Any help here would be appreciated, thanks in advance!

[MatheusC]

@Wahab 

Is this the result you want to achieve?

To do this, you can use the expression below, removing the 'Report'.

=Aggr(only({<Function-={'Reporting'}>}Function),Function)

uncheck null values.

Regarts, Matheus

[Wahab]

@MatheusC thanks for the reply.  I want to only show the Store and Systems column, not the Function column.  The results look correct, but when I remove the Functions column, it doesn't filter to just those anymore.

[MatheusC · Accepted solution]

Got it, so do this for these 2 dimensions just Store and Systems

Store

=Aggr(only({<Function-={'Reporting'}>}Store),Store)

Systems

=Aggr(only({<Function-={'Reporting'}>}Systems),Systems)

Regarts, Matheus

[Wahab]

Thank you MatheusC!!  That worked!!