How can i plot Grand Total Values, Obtained from Column Algorithm blocks, On Line Graph ?!
How can i achieve this on board ?
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.
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.
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.