Exclusion on dimension

[#1]

Hi Experts,

I have a pivot table with dimensions branch name, branch no. and some sales expressions.

there are around 200 branches and i need to exclude some 10 branch codes in the dimensions.

how can i do that.

plss help

[sunny_talwar]

Try this:

If(not Match([branch name], 'branch1', 'branch2', ....), [branch name])

[sunny_talwar · Accepted solution]

or

If(not Match([branch no.], 'branchCode1', 'branchCode2', ....), [branch name])

use whichever dimension you want to use for exclusion of branches.

HTH

Best,

Sunny

[giakoum]

or set up a flag in your reload script so that you don't have it hard-coded in your application expressions

[buzzy996]

soem thing like,

=sum({<branches-={list down all brances whcihevvr u have exclued,like '101','102'..etc}>}sales)