Avatar of Akulaj
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
Crystal Reports

Avatar of undefined
Last Comment
Mike McCracken

8/22/2022 - Mon
Mike McCracken

Can you show what you want the output to be?

mlmcc
Akulaj

ASKER
This is how I want it but only Grand Total Values has t ocopy. Pls help.

Grand-Total-Values.docx
Mike McCracken

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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Akulaj

ASKER
I'm using 2008. .

There might be some solutiion for it. please help me
Will

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
ASKER CERTIFIED SOLUTION
Akulaj

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mike McCracken

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.