Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ...
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