en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Thomas  
#1 Posted : Tuesday, February 20, 2018 12:05:11 PM(UTC)
Thomas
Rank: Newbie

Groups: extranet\Forum
Joined: 2/20/2018(UTC)
Posts: 1

Hi

I have a pie chart where I would like to show the total value in the title of the chart. The chart has one dimension and one measure.

I can only get the title to show the value of the first measure.

Is this possible to achieve?

Thanks.

/Thomas
Ole  
#2 Posted : Friday, February 23, 2018 7:00:33 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 433

Hi Thomas,

With the 2017 version, you have extensive options for formatting titles, labels and mouse over texts in charts - including pie charts.

Here is what you need to do:

- In your Chart / Title property, click the plus button to "Open advanced text editor".
- In the now larger editor field, click the plus button (again) to add <New lookup value for ...measure...>
- In the "Value override" box, type 'column.sum' and hit the Apply button.

This should show the Total value in your title.

You can read more about these advanced options in the client's online help (F1) by searching for 'column, row and axis calculations' and 'other operators'.

BR / Ole

Edited by user Friday, February 23, 2018 7:01:47 AM(UTC)  | Reason: Not specified

I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok