Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
As you have read, I have a small problem that I cannot solve on my own.
I need to sum all red values, so that I can get the percentage marked in green.
The blue values should be suppressed, and the final chart should look like picture 2.
I have tried with Len(trim(Location)>0, Location) as a calculated dimension, as well as adding same conditional to the expression.
Also I have attached the sample qvw with scrambled data, which is the application that I'm having trouble with.
Thanks in advance
instead of a constant number assigned to the variable TotalSizeOfQvw, modify its definition to
=sum(total {<Location=E({<Location={''}>})>}Workfiles.Length)/1048576
and make sure to check suppress when value is null for Location dimension.
instead of a constant number assigned to the variable TotalSizeOfQvw, modify its definition to
=sum(total {<Location=E({<Location={''}>})>}Workfiles.Length)/1048576
and make sure to check suppress when value is null for Location dimension.
Select "Suppress When Value is Null" option on the Chart Properties --> Dimensions
in addition to the two things in my previous post, you need to check show partial sums in presentation tab. then you will have the following:
Could you please send me qvw?
here you go!
sorry try this one...
ps: the variable seems to be getting recalculated at document open. use the following expression for Total size in %
sum(Workfiles.Length) / sum(total {<Location=E({<Location={''}>})>}Workfiles.Length)