Need help on avg%

[antonybi]

Hi Folks,

Please help me out to calculate avg % for the corresponding Market. 

PFB, for your reference.

Look forward to quick response.

Thanks,

[sunny_talwar]

What expressions are you using right now? and what is the output you are looking to get? Can you may be share a sample?

[antonybi]

Hi Sunny,

Thanks for the quick response.

I've two measures datavalueA and datavalueB.

In straight table , I've taken two dimensions Market and data and expressions are
Avg(datavalueA) and Avg(datavalueB) and showing in% as I highlighted in red.

Now I have to show one more measure which is having avg of datavalueA and dataavalueB(hightlited in red mark).

Kindly help.

[sunny_talwar]

You want to find the average of the two expressions? May be this

(Avg(datavalueA) + Avg(datavalueB))/2

[antonybi]

Sunny check the below attachment for the same.

Dimension: Market

Dimesion2: Data

Exp1: Avg(datavalue_A) //showing correct

Exp2: Avg(datavalue_B) //showing correct

Exp3: Sum(datavalue_A)+Sum(datavalue_B) // showing wrong

As soon as I select Market it should reflect avg of both datavalue_A and datavalue_B

Hope this clear.

[sunny_talwar · Accepted solution]

Is this what you need?

[antonybi]

Yes Sunny thanks for help. this is what exactly I need