group by

[#1]

Hi All

Here is my problem

When there are multiple markets within one application the market share calculations are not grouping by market. Instead they are using the total of all markets in the denominator of the % calculation. Any help will be appreciated.

[#2 · Accepted solution]

Could you show us your expression?

I'm guessing you are doing something like:

Sum(Sales)/Sum(TOTAL Sales)

If so, you want:

Sum(Sales)/Sum(TOTAL <Market> Sales)

[#3]

I don't have expression handy. But, as soon as I get to work tomorrow I'll share the expression.

[#4]

(sum(PRJTD_NRX_CNT)/sum(All PRJTD_NRX_CNT)) This is what I am doing. What I want it to do is respect the current selection of market in the denominator. I think ALL word is the problem here.

[Oleg_Troyansky]

Yes, you are right in your assessment - keyword ALL ignores all the selections and always returns the summary for the whole document.

As an alternative, symbol TOTAL will ignore Chart Dimensions, but respect User Selections. In addition, if Market is one of your Chart Dimensions, you can use TOTAL <Market> to limit your summary only to the relevant Market.

cheers,