a peculiar row level aggregartion

[#1]

I have a peculiar case now .

I have a huge table with Income numbers with different types of costs and transactions listed.

Now i have to display a summary table like this

where MISC=Revenue-Expenditure-taxes

Desc	Cost
Revenue	1000
taxes	200
expenditure	300
misc

view is structured in such a way that sum(Cost) yields the total number of respective Cost in Desc except "Misc" which is a calc value.

Now i dont understand how to write the expression.

is there any work around?

Krishna

[jagan]

Hi,

Can you attach the qlikview file.

Regards,

Jagan.

[vijay_iitkgp]

Hi ,

You can create these expressions without any dimension in Pivot table and transpose it.

[vijay_iitkgp]

Exp1: Sum(If(Desc='Revenue',Cost))

Exp2: Sum(If(Desc='Expenses',Cost))

Exp3: Sum(If(Desc='Tax',Cost))

Exp4: Column(1)-Column(2)-Column(3)

And after that drag it to vertical