adding sub category

[sagaraperera]

Dear All

As the example follows script

Description	Amount
Fixed Asset	1200
Depreciation	150
Total Net Asset	??????

i want to know how to get this adding command with description of Total Net asset.

sagara

[niclaz79]

Hi,

Exactly what you are after is not clear, however if you are looking at having Total Net Asset as a sum of the above lines in the script, it's very easy:

LOAD

     [Fixed Asset],

     [Depreciation],

     ([Fixed Asset] + [Depreciation]) as [Total Net Asset]

FROM ...

[avinashelite]

If you have the Description and Amount as columns in your  data set then ...

1.Add a straight table or Pivot table

2.Add the Description as the dimension

3. Expression sum(Amount)  and enable show Expression total in straight table or partial sum in Pivot table