Expression in my pivot table - exceeding 100%

[#1]

Hello,

As you surely will tell from this post, I am new to QV10, and have a problem creating an expression in a pivot table.

My data has Country and State as dimensions.

My expressions are

SUm({<month_name ={June}>} (Numerator)/(Denominator))

Same for July, August etc

This works fine when the pivot table is opened down to State, but when grouped up to Country, the % for the country is just the addition of all the state %'s; not the recalculation.

Please can someone show me where I am going wrong?

Thanks in advance.

J

[whiteline · Accepted solution]

Hi.

Your expression is wrong for Country level. You have more than one value for Numerator and Denominator on this level.

You should use aggregation functions, for example like this:

=sum({<month_name ={June}>} Numerator)/sum({<month_name ={June}>} Denominator)

[#3]

Thanks for the giudance.

[#4]

Thanks for the giudance.

[#5]

Thanks for the giudance.

[#6]

Thanks for the giudance.

[#7]

Thanks for the giudance.