4 Replies Latest reply: May 17, 2013 1:49 PM by Steve Zagzebski

# Calculated Dimension

This seems like it should be simple.

I need to create a a product straight table with many different expressions.

We have many products but the user is requesting that only one of the products shows up in this table (dimension). I realize just selecting that Product from a list box is the easy way but he is trying to get it so you don't even have to make a selection. So product A is the only one that ever shows up in this table...and the expressions just follow suit.

• ###### Re: Calculated Dimension

You can change the expressions a bit so only results for product A are shown. For example sum(sales) becomes sum( {\$<product={'A'}>} sales). That's the most straight forward way to achieve this imho.

• ###### Re: Calculated Dimension

Tthanks for the response. I figured I might have to go through the expression. Just thought there might be a simpler way of just doing it one time in the dimension instead of having to incorporate that set analysis into every expression. then if there is a change each one of the expressions has to be updated.

• ###### Re: Calculated Dimension

You could use a variable in the expressions: vProduct. The expression would become sum({\$<product={'\$(vProduct)'}>}sales). You'll only have to change to variable.

Of course you could also use a calculated dimension instead like if(product = 'A', product) and check the option Suppress When Value Is Null for that calculated dimension.

• ###### Re: Calculated Dimension

That works perfect. thanks