Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
in label try like this
=Month_Year &'Total : '
I have tried like this only but it shows only :
Total: