Need to get last month value in the total

[#1]

Hi,

I need to show the maximum month value in the sub total column.

i attached sample file.

thanks in advance.

[#2]

You can use Dimensionality() to define a specific expression for the total column. Is this what you want?

[#3]

Hi,

thanks for your reply.

I need to show the maximum month value, i.e., if i select 2013 and jun month, then i need to show the values from jan to jun and my total column should show as jun month value.

if i select mar month, i have to show jan to mar and total column shoud be Mar month value.

Hope it will be clear.

thanks in advance.

[#4]

Hi gopinathanl,

please see the modifyed example.

Hope that´s what you are looking for.

Good luck!

Rainer