Akulaj
asked on
Copy Values from Row to another Row in Crosstab
HI Gurus,
I posted the same question and tried ot solve mysefl using Calculated Memeber.
I was trying to copy the values from "Capital" to "Depreciation" using Calculated member function but User want to see the values only in Grand total section but not in Fiscal year section of crosstab.
Attached is the sample report. Kindly help me.
Datasource is Bex and Structure.
Sum-in-Depreciation.rpt
I posted the same question and tried ot solve mysefl using Calculated Memeber.
I was trying to copy the values from "Capital" to "Depreciation" using Calculated member function but User want to see the values only in Grand total section but not in Fiscal year section of crosstab.
Attached is the sample report. Kindly help me.
Datasource is Bex and Structure.
Sum-in-Depreciation.rpt
ASKER
I don't think that can be done. I know it can't in versions CR XI and before. CR2008 added the calculated field but I think that is for another use.
mlmcc
mlmcc
ASKER
I'm using 2008. .
There might be some solutiion for it. please help me
There might be some solutiion for it. please help me
Akulaj
I agree with mlmcc , that there is noway to accomplish this in a Cx tab, but:
Here's what I am thinking (By the way the field naming convention is tedious):
You will have to manually create the cx tab as a report (similar to what I have attached). I have created accumulators for some of the categories, which are rest to zero on the change in each fiscal year. The easiest approach is to flip the rows and the columns, this way fiscal year can be 1.....n If you can't convince your client to accept that, then you will need to create accumulators for each fiscal year, this will however restrict reporting to so many fiscal periods across. Flipping the rows and columns is the most expedient and less cumbersome approach and the report attached accomplishes that for you.
different-approach.rpt
I agree with mlmcc , that there is noway to accomplish this in a Cx tab, but:
Here's what I am thinking (By the way the field naming convention is tedious):
You will have to manually create the cx tab as a report (similar to what I have attached). I have created accumulators for some of the categories, which are rest to zero on the change in each fiscal year. The easiest approach is to flip the rows and the columns, this way fiscal year can be 1.....n If you can't convince your client to accept that, then you will need to create accumulators for each fiscal year, this will however restrict reporting to so many fiscal periods across. Flipping the rows and columns is the most expedient and less cumbersome approach and the report attached accomplishes that for you.
different-approach.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
mlmcc