Pivot Table Total custom Label

[Anonymous]

Hi,

  I have attached a snaphot of a Pivot Table,,

     In my report format, I want the Total label to be the same as the first column grouping...

      Is it possible? Ive tried to explore making the total label as an expression but its not giving any value..

   Many thanks for the assistance....

[#2]

Dear Saima,

I think we can give different names to all the dimensions we have.Just select the desired dimension and on Option 'Label for Totals' we can give the name as per our requirement.

Thanks

[#3]

Hi,

Can you share a file.That will help understanding the exact requirement.

Thanks

[#4]

Yeah but that is for each dimension.... N we need seperate labels for each value in the dimension. For Eg: if you have a field Name having 3 values ABC,XYZ,DEF so you should be able to give the total label as ABC Total, XYZ Total, DEF Total.....

[Anonymous]

so its really not possible...

Thanks evryone,,, i love this community... very alive and helpful 😃

[#6]

Hi,

I think that won't be possible however you can use a Text Box with the name as per requirement and fix that e accordingly.If that helps.

Thanks

[#7]

But placing textbox wont help since the table might change with each selected filters

[#8]

Hi,

PFA...Try This.

Thanks

[#9]

Kewl....

Thats upon the selection... what if one needs without selecting...????

Then it would be next to impossible

[#10]

Unfortunately this is the best we can do at the moment.

[avinashelite]

can you please close this thread and mark it as answered