How can i plot Grand Total Values, Obtained from Column Algorithm blocks, On Line Graph ?!

Malav Shelat

Hello All,

 

I have one scenario where i am thinking how can i plot graph based upon Grand Totals,

 

here is the example of that same scenario,

 

 

 

I have the table as shown above, Fees Lost and Fees New are two blocks which i have created using Column Algorithm, 

• These two blocks shown above are based upon other column which i have Hided using Hide this block optio
• In The Layout > Axes Tab
  • in By Row i have Hierarchy like : Test ; Subtest     |    in By Column : Month 
• And so we get the above Dataview as show in the Pic

 

Now what i want to do is like this: (i am using paint as an illustration)

 

• I'll Copy the layout of the DataView and Paste it into Layout for Chart (line Chart)
• I want to display the Grand Total values for each month on Graph , Just Grand Total Values only, Like this

 

 

How can i achieve this on board ?

 

Help needed,

 

Thanks and regards,

Malav

Björn Reuber

Hi,

 

in the DV you have severyl by row entities, are those also included in the chart? cause if this is the case the Grand total line from your DV should also be displayed directly

 

regards

Björn

Previous Member

 Yes whole Layout in chart is same as DV, Apart from that Chart does not support hierarchical Values in Column , 

i Grand total for Fees Lost and Fees Gain displayed By Months (Months on X-axis)

Previous Member

*** I want Grand total for Fees Lost and Fees Gain displayed By Months (Months on X-axis) ***

 

Dietmar Jeschkeit

Hi Malav,

 

if I understand you right you want to show a graph like this:

You can get this if you delete your entities by row and insert month by row. No entity by column. The X-Axis in graphs is corresponding to the entity by row (not by column), so for graphs you often have to switch the entities. 

So if you have no entity by column you will see the "grand total" automatically. Don't forget to switch off the "sum" on the axes-tab.

 

regards

Dietmar

Previous Member

Hello Dietmar Jeschkeit,

 

You've got me completely right , i already tried doing that earlier but the problem is the the Grand Total is being Calculated upon the Conditional algorithm based upon the Entities in row , so if i remove them i'll not be getting desired results.

Dietmar Jeschkeit

OK, therefore you can write your result back to cubes (using procedure or nexel).

Or depending on how many Elements you have in your entity you can set the entity by column. What you get is a line and a legend for every element of the entity. Now set the color to transparent for each element. Format only the TOTAL in the color you want.

Previous Member

Thank you very much for your help Dietmar Jeschkeit . I now know thanks again