EXCEL 2013 PowerPivot: how can i use different labels for the for column and row grandtotals ? RRS feed

  • Question

  • I am using row and column grandtotal in PowerPivot but i cannot rename the labels seperately.

    How can I achieve this ? I cannot use VBA because of SharePoint 2013.

    Thursday, March 2, 2017 11:14 AM


  • Hi eyeekit,

    Based on my understanding, I create a pivot table like the screenshot below.

    Do you want to change the "Row Labels" and "Sum of Value" name? If it is, you can click the name, you will get the following catalog. Then rename in the blue highlighted box.

    If you have other issues, don't hesitate to let me know.

    Best Regards,

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, March 3, 2017 2:55 AM