Calculating a Share in a Straight Table

[Anonymous]

Hi,

I need to calculate a Share in an unusual way.

Could you please have a look in the file attached and help?

Thank you in advance,

Larisa

[sunny_talwar · Accepted solution]

Try this:

Only({<Edition=, Group=>}Value) / Only(TOTAL <Wave>{<Edition={'Major'}, Group={'All'}>}Value)

[Anonymous]

Thank you!

[maheshkuttappa]

Let me know if this works

[maheshkuttappa]

attached file