Notifications
Announcements
No record found.
Can we have different row definitions for different columns in one row ?
*This post is locked for comments
Hi mshuhaib20,
Why do you need different rows for your columns?
What kind of report do you plan to create?
Best regards,
Ludwig
Income statement .
The row as you can see needs info from the sites and the finally total
Hi,
For this report you need only a single row structure.
In your column definition you can then link the different columns to your financial dimensions.
I did that here for various cost centers that I have in my demo system
In your case you whould have to define a Dimension filter based on the financial dimensions that define what you want to see in your columns.
Hi Ludwig
thanks for your valuable reply
it Worked out for all the columns .
As you notice the Last Row of the Income statement i uploaded contains net profit last year
how do i populate this value
Do you have the not profit from last year posted on a specific account (e.g. retained earnings 2017)? If this is the case then you can make use of the row modifier functionality.
On the other hand, if you have to calcualte the previous year value the same way that you calculate the current years value, additional columns are required and you (a) either have to change the layout of your report in a way that you show the current year data column next to a previous year column or (b) make use of non-printing columns for calculation purposes to show the result as outlined in your report.
Some time ago, I have done something similar to what I describe for (b) but it took me a while to design the Report. Therefore, I would recommend if you can go with (a) because it is much faster and easier to implement.
HI Ludwig
I would like to Use option (b)
Could you guide me on how to use it ?
I Can use non Printing Column but how do i populate the value in another column , Like Last year column in this year column but Last year profit row
Can you have a look at the default column definition 'summary trial balance year over year default'?
In this column definition you can see how previous year data can be incorporated; simply by entering base-1 in the fiscal year row. That's what I described as (a).
For solution (b) you have to include both results in your row definition and use non-printing rows. Tried to illustrate you the setup principle in the next excel screenshot
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
Ali Zaidi 2
