I NEED OUTPUT IS LIKE BELOW

[mitwa]

     I NEED OUTPUT IS LIKE BELOW
we can get it by union of two queries but i dont know how???
                                    Actual (A)
                                    Q3 2009
                                    ---------------
total revenue                  $70,359

Cost of Goods Sold     43,733

PRETAX                          26,626
                                     37.8%

Overhead Expenses     18,089
                                      25.7%

  Operating Margin       8,537
                                      12.1%

GROSS MARGIN             8,555
                                     12.2%

EBITDA                           5,285
                                        7.5%

from the above i know how to take Total Revenue,Total COGS,PRETAX,Overhead Expenses,Operating Margin,GROSS MARGIN
,EBITDA but i dont know how to get that % columns..formula for tht % columns is like gm= gm/revenue

[Sridhar Vuppugalla]

Hi,

If you have two different Queries, we need take no of query items in both queries then give it to same name for query items in both the queries. Then u union the both queries.

[mitwa]

thanks for responding.. but i think you are not understanding my requirment..to get that percentages we can get it by using crosstab or else we have to go through unions...problem s i dont know how to solve in both the ways

[colt]

I guess most probbly you are looking for a dataitem:

gm=gm / total(Revenue); Maybe you have  to use gm=gm / total(Revenue within set Q3/2009)

[mitwa]

no problem with dataitem, i gave it as

for dataitem1:

CASE  WHEN [KPI]='PRETAX' THEN [Actual(A)]
            WHEN [KPI]='Overhead Expenses' THEN [Actual(A)]
            WHEN [KPI]='Operating Margin' THEN [Actual(A)]
            WHEN [KPI]='GROSS MARGIN' THEN [Actual(A)]
            WHEN [KPI]='EBITDA' THEN [Actual(A)]
            END

for dataitem2:

case when [KPI] in ('Total Revenue';'Total COGS';'PRETAX';'Overhead Expenses';'Operating Margin';'GROSS MARGIN';'EBITDA') then ('Total Revenue') end

for dataitem3:

[Data Item1]/[Data Item2]


but i am not getting the output. dont know y..pls help me

[Francis aka khayman]

first questions that should always be asked... are you using DIMENSIONAL or RELATIONAL?

[mitwa]

It is an relational package.

thanks for everyone i got near by output..

now my report is look like     

total revenue                  $70,359
                                         20%

Cost of Goods Sold        43,733
                                          10%

PRETAX                           65,486
                                          22%

Overhead Expenses         34,535 
                                          66%

now the problem is i dont need those % values for only total revenue and  Cost of Goods Sold.
* using static choice how to remove this..
* (remember that those total revenue ,  Cost of Goods Sold, PRETAX , Overhead Expenses are in kpi )