Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
or
If(not Match([branch no.], 'branchCode1', 'branchCode2', ....), [branch name])
use whichever dimension you want to use for exclusion of branches.
HTH
Best,
Sunny
Try this:
If(not Match([branch name], 'branch1', 'branch2', ....), [branch name])
or
If(not Match([branch no.], 'branchCode1', 'branchCode2', ....), [branch name])
use whichever dimension you want to use for exclusion of branches.
HTH
Best,
Sunny
or set up a flag in your reload script so that you don't have it hard-coded in your application expressions
soem thing like,
=sum({<branches-={list down all brances whcihevvr u have exclued,like '101','102'..etc}>}sales)