Now the problem is image src="%%jLZ%%" can have dynamic rows anything between 2 to 10 and I have set the Data displayed height to 1350px. Now when 10 rows are coming all looks good but when 2 rows are coming in the chart then there is a big space between the chart image and the text below it (Please refer to following links .....) which is not looking good.
you would need to create grouping dimension and use that a a column in the table. Dim1 would be your normal dimension, and Dim2 would be your grouping dimension. sample below. then instead of using dim 1 you would use dim2 in the table. That is concept used to create subtotals, grand totals, P&Ls etc in straight tables. I can only point you in the direction as those kinds of solutions are very much based on individual scenarios so detailed explanation can be hard at the moment.
dim1
dim2
a
a
b
b
a
grand total
b
grand total
With the above your Grand Total is basicaly just another value in straight table
hope this makes sense
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
