Could you please attach sample data as twbx?
Did you tried
case attr(sort by)
When "A" then Value
when "B" then Value
If there is any aggregated fields in your calculation maintain all the calculation as aggregated
Hope this helps .
Plz mark this answer as correct and helpful to close the thread
I suspect if you wrap [Total Members], [Total Calls], etc in SUM() then it will work.
If you aggregate one of the items, which you are doing with % member called, all items need to be aggregated.
all of your "Total - " calculated fields are aggregates but your sort by field in not an aggregate - you need to aggregate it with Attr() to make the expression valid
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
What you have to do is either convert all in non aggregated form using ATTR
or convert all measures in aggregated form using sum.
Please check with this.
Yes i tried this but it is not working.
could you please share twbx so that i can revert it with calculation, if possible.
I uploaded the twbx file. I have tried ATTR but not working.
Thank you all for all your help.
Please attach twbx from the beginning.
And please read all of the answers...