Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I need to create a bar chart which displays the sum of specific values of a field called "Categoria".
Below is the printscreen of the field in my data base:
I don´t want to sum the values "Mulheres" and "Homens", it should be removed from the result of the sum.
Thanks,
You want at dimension level or Expression level?
try dis,
sum( {<Categoris= {'Mulheres','Homens'}>} Categoris )
At dimension level you can try like:
Edit your dimension with:
if(Categoria<>'Mulheres' and Categoria<>'Homens', Categoria)
At Expression level you can do:
sum({<Categoria={'*'}-{'Mulheres','Homens'}>} Field) //as per your requirement
try this
sum( {<Categoris -= {'Mulheres','Homens'}>} Categoris )
Thanks for your help guys.
I forgot to say that i need to divide the result of the sum by the value of "Regular Employee" of each year.
For example, here is the sum from 2014:
And than, i need to divide the result of the sum (1295), by the value of "Regular Employee" (897) of the same year:
Thanks
then try this:
=(sum(YourField12)/sum({<YourField={'Regular Employee'}>} YourField12))
In brief after your requirement sharing:
Take this as a Dimension:
if(Categoria<>'Mulheres' and Categoria<>'Homens', Categoria)
and
Expression: =(sum(Amount)/sum({<Categoria={'Regular Employee'}>} Amount))
Somenthig went wrong, here are the values displayed:
I guess the sum expression is not doing the sum by year.
Note that Year is a dimension of my chart.