'TOTAL' in GRID CHARTS

[#1]

Hi all,

How to display the total on both sides(horizontal and Vertical) in a grid chart?

PS: just like attached excel snapshot

any help would be appreciated.

Regards,

Susvith

[israrkhan]

Hi,

Grid Chart Shows data in Symbol/ graphical way, not in text format..

i think you cant do it,

But, you can create label object and place them below each total, and set layout >> layer property to top,  for all labels.

and in label you can use the expression to calculate totals.

it might work...

[Gysbert_Wassenaar]

It should be possible if you create two new dimensions in the script based on the two you use in the chart. Suppose you have a dimension Product:

Product
Apple
Banana
Chocolate

The new table would look like this:

ReportProduct	Product
Apple	Apple
Banana	Banana
Chocolate	Chocolate
Total	Apple
Total	Banana
Total	Chocolate

Now you can use ReportProduct in the grid chart instead of Product to show the totals too.