How to show percentage for each Dimension value in Text Pop-up excluding Dimension Limits setting?

[jblomqvist]

Hi all,

I have a bar chart where my Dimension is ClaimType.

The dimension values could be Internal, External, CompanyMeetings, Marketing, etc.

My Expression is Sum(Value).

My Dimension Limit is Largest 5.

How can I get my bar chart to show the percentage of value based on all claim types beyond the dimension limits?

I want to show this in Text as Pop up in the bars.

I've attached an example app to help illustrate.

In there the top 5 chart uses dimension limits, the straight table shows all values. In the Bar Chart I want to see percentage of expenses that was for Training, Marketing etc and not just be limited to dimension limits.

Anyone know how this is possible?

[tresesco · Accepted solution]

Try expression: =sum(Value)/sum(Total Value)

[Clever_Anjos]

Sum(Value)/Sum(Total <ClaimType> Value) should return what you need

[jblomqvist]

Hi Tresesco and Clever,

Thanks I think =sum(Value)/sum(Total Value) works.

What is the difference between TOTAL function and doing Sum({1} Value)?

[tresesco]

{1} - is set analysis modifier; ignores all selections in same state.

Total - ignores the dimension but selections