Calculated dimension total

[nareshthavidishetty]

Hi,

I have used calculated dimension but here i need to show total for this.

Calculated dimension: =aggr(sum({<Date={$(varMaxDate)}>} TOTAL_ORDERS_DAILY_NEW),Loc)

Table used : Pivot

Please find the below image.Here i need to show total of total orders.

Thanks..

[#2]

[MK_QSL]

Use it as an expression rather than calculated dimension

SUM(aggr(sum({<Date={$(varMaxDate)}>} TOTAL_ORDERS_DAILY_NEW),Loc))

[nareshthavidishetty]

Hi,

Attached is the sample application in which i need total for the total orders column in the table.

Thanks..

[nareshthavidishetty]

Hi,

Please let me know if we can get this.

Thanks..

[MK_QSL · Accepted solution]

Like this?

[nareshthavidishetty]

Hi Manish,

It's very smart.

But i need it to show in bottom of the report.

Thanks..

[Anil_Babu_Samineni]

Try to go Bottom and see whether values are there not not there? Would you confirm there. I got to see bottom with all values{I mean without any missing Total Values}

Would you check that?