4 Replies Latest reply: Jul 10, 2013 4:30 AM by stevenfosters

# Calculate with Set Analysis

Hi evereybody

I have a calculated dimension like this: if(Account_Group = 'WHVIGREV','Gross Revenue', ..., Null())

This dimension works perfectly!

I created a bar chart with the calculated dimension and as an expression a Set Analysis like this: Sum( {\$ <  Version={ACT}, Account_Group=  > } EUR*-1)

It works too!

But now I´d like to create a bar chart where I can calculate with Set Analysis like this: Sum( {\$ <  Version={ACT}, Account_Group=  > } EUR*-1) / Sum( {\$ <  Version={ACT}, Account_Group= {WHVIGREV}  > } EUR*-1)*100

In this case WHVIGREV is Gross Revenue and I want to show the percentage of every position in the calculated dimension of WHVIGREV (Gross Revenue).

Could anybody help me?

Regards

Steven

• ###### Re: Calculate with Set Analysis

try this

(Sum( {\$ <  Version={'ACT'}, Account_Group=  > } EUR*-1) / Sum( {\$ <  Version={'ACT'}, Account_Group= {'WHVIGREV'}  > } EUR*-1) ) *100

• ###### Re: Calculate with Set Analysis

try this,

in first expression-Sum( {\$ <  Version={'ACT'}, Account_Group=  > } EUR*-1)

in second expression- Sum( {\$ <  Version={'ACT'}, Account_Group= {'WHVIGREV'}  > } EUR*-1)

in third expression-- (column(1) / column(2)) *100

• ###### Re: Calculate with Set Analysis

Thanks for your really fast help

If I understand it right, it is not possible to calculate with two Set Analysis / to combine two Set Analysis in ONE expression?