IF in a calculated dimension

[meckeard]

Hi All,

I have a bar chart that shows customer ages along the X axis with the count of customer with that age along the Y axis.  The dimension for this uses a field called Cust_Age.  That works fine but I need to only get the Cust_Age for 6 of my company locations that are in a field called Freq_BranchName.  I tried to update my dimension to a calculated Dimension like this:

=If(Match(Freq_BranchName, 'Blue Bell', 'Havertown', 'Lawrence Park', 'Limerick', 'Secane', 'Springfield' ), Cust_Age)

This didn't work.  It seemed to sum all the values for Cust_Age. 

I tried to put this logic in the "Enable Conditional" field but that made no change to my graph:

Match(Freq_BranchName, 'Blue Bell', 'Havertown', 'Lawrence Park', 'Limerick', 'Secane', 'Springfield' )

What can I do to get only Cust_Age where Freq_BranchName is equal to the 6 names above?

Thanks!

[dplr-rn · Accepted solution]

in your expression use set analysis like below 

Sum({<Freq_BranchName={'Blue Bell', 'Havertown', 'Lawrence Park', 'Limerick', 'Secane', 'Springfield'}>}Sales)

[meckeard]

Dilipranjith,

Thanks, that was close to what I needed and I was able to get it to work.

Mark

[dplr-rn]

good to hear