Apr 09 2022 08:20 AM
I would like to include the grant total of the pivot chart into the title. Thank you for your time & patience.
Apr 09 2022 08:30 AM
Apr 09 2022 08:36 AM
Apr 09 2022 08:53 AM - edited Apr 09 2022 08:59 AM
@rservice0320 I thought you wanted it to include the word "Total". Then it becomes a text and you can wrap the "number part" in the TEXT function to format it in the way you want. In your example, the total is 120 thousand, so that will be 0 million. Is that really what you want?
PS: Perhaps better not to mark your answer as "Best" when you still have questions to be resolved.
Apr 09 2022 09:11 AM
Apr 09 2022 09:36 AM
@rservice0320 See attached!