How to show total of a stacked bar chart

[ferchops1987]

Hi everyone,

I searched it in several post but i didn't found how to solve my problem. Actually, I am not able to display the total of a stacked bar chart, it repetes the result as many times as values of dimensions there are. I want to show just one.

The expression is (It corresponds for the result in gray):

	num(
		sum(TOTAL <"Periods"> {<[_ContractedProjectFlag]={1}>}[Project volume])
		,$(vU.Format.0D)
	)

Periods: cycle dimension which contains some dimensions relative to dates.

I would appreciate so much any help

Thanks,

[Anonymous]

On the presentation tab untick Plot Values Inside Segments.

Or you could tick Still Show Total on Top so you get it both by dimension and the total.

[ferchops1987]

Hi Bill,

I want to have both values, by dimension and the total. The problem is whether I tick <Still Show Total on Top>, I do not know how to format this value. I am using variables to be able to transform the numeric format, using num() function and a list box which allows to do the selection of format. What ever, if I put it manually in the number tab, I lose this dynamism.

Some idea to achieve it?

Thank u very much.

[rupamjyotidas]

Why not use Text as Pop up to help you out

Probably the link below will help you

Define Your Pop-Ups

[kkkumar82]

What is the number format of your expression, I think your number format should be "Expression default"

[ferchops1987]

I am using a variable which contains calculated dimensions for the first expression (Two option in this case). The same for the second one.

[ferchops1987]

Hi Rupam,

Finally I do it, because I think there is no way to deploy what I want...

As you can see I can format the number in the pop up, but I can not in the graph.

Thank you.

[#8]

Hi ferchops1987‌ , could you post the solution, we just migrated to QV12, and suddenly it's repeating the values.

Would like to know how you solve it.

Many thanks

[ferchops1987]

Hi Martin,

I am using Combo Chart, so in the tab Expressions I've chosen "Values on Data Points" and then in the Presentation tab in the "Values on Data Points"...