Search
Search

Output Error in Yearly Report

Hello friends i need to show the following output in a query please advise :

-

Net Post----

-

Per1....Per2....Per3....Per4--so on.......Diff.....% Change

Post1

---Post2

-

Post3

-

Year1................x.......x.......x......x........

-

Year2................x.......x.......x......x........

-

Year3................x.......x.......x......x........

Now the user want to see the overall Difference in Netpost for Years

And user want to see the Overall Percentage Change in Netpost for different years.

So user doesnot want to see Difference between Netposts for Different period , but as it is Year by Year report, the user want to see the overall Difference in Netpost and same way Overall % change for 2 Years.

As i can use only 2 structures, 1 for keyfigure and 1 for Char..

How to achieve this ?

Former Memberreplied

Hi Kartikey,

<i>"Now as years are in different structures in rows, and my columns are in Keyfigure structures, so i cannot create formulae for the same."</i>

<b>This is true. you can not create formulae in keyfigure structure</b>

<i>Even if i use Cell editor, i will not be able to create formulae for the Different Years overall difference and percentage variance.</i>

I am not sure why you are not able to use cell editor?

If you have implimented all my steps your query out put should be as follows.

.............P1........P2........ P3..so on..P( Toal).... Diff......... % change

Year1....Y1P1....Y1P2....Y1P3........Y1P

Year2....Y2P1....Y2P2....Y2P3........Y2P..... (Y2P-Y1P).....(Y2P - Y1P)%AY1P

In KF structure

P(Total) = P1P2P3 and so on

Diff = Can be anything example Create CKF which is (P1-P2) give description Diff. The main purpose of creating this is to populate empty column which will be filled using cell editor..

Same thing with % change

You can Hide P(Total) if you do not need this to be displayed.

using cell editor you should be able to write formula Y2P-Y1P and (Y2P-Y1P)%AY1P.

Jaya

0 View this answer in context