Add Totla to an Object

[gidon500]

Hi ,

I have a document  , that compare Sales actual vers Budget ,

i have used the FactType , ine line data to creat the ERD

and in the Object I used the FactType , Actual , and Budget ,

and many expresions to  create the data

i need to  add a Total column  accoring to the excel file  attached  , and the original qvw Document

Need help

thanks

gidon

[bindu_apte]

Hi,

It is asking userid. Please give credentials so that will help you out.

[soloeeeoff]

Please, give us USERID... That I may try

[gidon500]

wow , sorry

userid : gidon

passwd: david

thanks

[gidon500]

Hi Bindu ,

did you succed to open the file

thanks

gidon

[Anil_Babu_Samineni]

Where you are expecting Total column with those sub headers?

[gidon500]

QUARTER_YEAR	2016-Q1		2016-Q2		Total
FactType	Actual	Budget	Actual	Budget	Actual	Budget
Income	1,217,391	237,082	1,325,748	222,203	2,543,139	459,285
Cost	1,054,541	205,804	1,159,293	190,988	2,213,835	396,792
Profit1	162,850	31,278	166,455	31,215	329,305	62,493
%	13.38%	13.19%	12.56%	14.05%	13%	14%
SalesCost	68,669	11,409	70,185	11,409	138,854	22,818
ManagmentCost	59,857	12,780	58,480	12,780	118,337	25,560
Cost2	128,526	24,189	128,665	24,189	257,191	48,378
Profit2	34,324	7,089	37,790	7,026	72,114	14,115
% Profit2	2.82%	2.99%	2.85%	3.16%	2.84%	3.07%

[gidon500]

if  you change to dimention to quarters

i want to add total  like in the enclosed excel file

gidon

[Anil_Babu_Samineni]

Have you tried Transpose with the dimension and Calc. Expr. of two (Actual, budget)

[gidon500]

No  i did not

can you show me how ?