Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am doing simple count
count(id) and for ratio count(id)/count(total id)
count(total Id) is incorrect.
in straight table i checked.in properties expression tab if i use Expression as total it showing correct.
how to do this bar chart.
Note: i am using cyclic group in dimension
i need to include max year in this. can some one suggest
You want to have only TOP 10 or for all?
Tatsiana Chetirbok just now noticed you included BW_MAKE_DESC but i am using cyclic group.check below i uploaded sample. plus i need to include max year
top 10 only bro
But..... there was no cyclic group in the sample qvw you provided.
To avoid confusion, it is always best to provide a sample that reflects properly what you have / are trying to do.
This thread has got really confused and is already marked as correctly answered.
I'd suggest you start a new thread for your new question.
Let me know if this is not what you want !
Ignore red lines in Expressions ... It's a bug !
Hello!
I attached my example. I am sure that expression can be more efficiency, but it only that I have done for now.