Prob in Pivot Table !!

[nikhilgarg]

HEy,

I have created a Pivot table.

In that table , i have done partial sum.

I want the label for that total to be Month_Year &'Total : ' , where Month_Year is my dimension.

But it is showing only Total: .  Month_Year is not appended to it.

IS there any way to append the dimension before Total like:

Jan2014 Total , Feb2014 Total etc.

Thanks

[tyagishaila]

Hi Nikhil,

You have to use variable for it, in the place of Label for Total (Below Show Partial Sums).

like:

=Year(vDate)

where vDate is you variable for it

[arulsettu]

in label try like this

=Month_Year &'Total : '

[nikhilgarg]

I have tried like this only but it shows only :

Total: