QUERY CALUCLATION

[sspk]

Hi All,
I a generating a cross tab report in which the rows have 'TERRITORY'(data item) and the column has 'group_1'(as data item which has 2 values like A and B).Now i need to caluclate the market share of A  (like (A/(A+B))).I am trying to create the query calculation is it correct,any suggestions and how to do it

[Suraj]

instead of group_1, use two separate calculated items:
one when group_1 = A and another when group_1 = B
that way, it'll be easier to calculate what you want.
one /(one + another)...

[sspk]

instead of group_1, use two separate calculated items:
one when group_1 = A and another when group_1 = B
that way, it'll be easier to calculate what you want.
one /(one + another)...

HI
Thank you,Can you  explain it in steps ,becoz it's not coming(even my cross tab corner cell is also a query calculation) is that the reason

[Suraj]

you don't have to have a calculated measure if you are doing it in the suggested data items. Just include the calculation in the suggested two data items.
for measure, you can use default measure from table.