Recently,I want to add many self-defined(calculated) data only in column-total-area(the right area or last area or the report),it does not participate in other column’s calculation,of course it does participate in other column’s calculation now.If there is a switch for that,it may be very useful in actual application.I need the switch.
Thank you for sharing this idea with us.
Currently such a switch is not available. As a workaround, you can try a dashboard approach where one pivot table would show the data and another would show totals only.
Hope it helps.