Dear All,
How can i get the Cross Tab with Formula
Rows GL -> Code and Text
Colunms ->This Year Month like (2012 April - 2012 March)
Last Year Month like(2011 aPRIL - 2011 mARCH)
Variance Like (This Year Month - Last Year Month)
This Year This Month Like (2012 April - 2012 March)
This Year Last Month Like(2012 March - 2012 Feb)
Varaince like (This Year This Month - This Year Last Month )
This Year YTD Like (2012 April)
Last YEAR YTD like (2011 April)
Varaince (This Year YTD - Last Year YTD)
How can i get the Colunms values please help me
| GL
Code |
|
Text |
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
2012 |
2011 |
|
|
2012 |
2012 |
|
|
2012 |
2012 |
|
|
| CONSOL GL |
|
|
Feb |
Feb |
|
|
Feb |
Jan |
|
|
YTD Feb |
YTD Feb |
|
|
| |
|
CURRENT ASSETS 流动资产 |
|
|
|
|
|
|
|
|
|
|
|
|
| 10010000 |
|
Cash and bank balances 现金及其等价物 |
This Year |
Last Year |
|
|
This Year |
This Year |
|
|
This Year |
Last Year |
|
|
| 10020000 |
|
Trade Debtors and Notes Receivables
(3rd parties) 应收账款(第三方) |
Month |
Month |
Variance |
|
This Month |
Last Month |
Variance |
|
YTD |
YTD |
Variance |
|
| |
|
Other receivables |
US$ |
US$ |
US$ |
|
US$ |
US$ |
US$ |
|
US$ |
US$ |
US$ |
|
| 10030000 |
|
Advance for property, plant and
equipment 固定资产预付款 |
|
|
|
|
|
|
|
|
|
|
|
|
| 10031000 |
|
Advances to suppliers 预付账款(付给供应商) |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10040000 - WIL |
|
Due by holding/fellow subsidiaries
(WIL) 控股/子公司应收款 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10040000 - WCL |
|
Due by holding/fellow subsidiaries
(WCL) 控股/子公司应收款 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10041000 |
|
Due by associates 联合股份公司应收款 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10042000 |
|
Due by related party corporations
集团关联公司应收款 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10070000 |
|
Other current assets 其它流动资产 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10050000 |
|
Inventories 存货 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10060000 |
|
Tax recoverable 可返回所得税款 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10080000 |
|
Derivative financial instruments
以业务为基础的金融手段 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10090000 |
|
Financial assets
held for trading 交易性金融资产 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10100000 |
|
Available-for-sale financial assets
可供出售的金融资产 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10200000 |
|
Held-to-maturity 持有至到期投资 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10210000 |
|
Gross amount due from customers for
contract work-in-progress |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| 10220000 |
|
Development property |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| |
|
TOTAL CURRENT ASSETS 流动资产合计 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
| |
|
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
| |
|
NON-CURRENT ASSETS 非流动资产 |
|
|
- |
|
|
|
- |
|
|
|
- |
|
IP Logged