Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try expression: =sum(Value)/sum(Total Value)
Try expression: =sum(Value)/sum(Total Value)
Sum(Value)/Sum(Total <ClaimType> Value) should return what you need
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)?
{1} - is set analysis modifier; ignores all selections in same state.
Total - ignores the dimension but selections