Stacked bar charts sorted by total, but without showing total

Questions & Answers
,
1

Hi,

I need to show stacked bar charts sorted by total but without showing the total. If I remove total column from the table, I don’t have a possibility to sort by total values.

Is there any way to do so?

image
image2822×1064 280 KB

2

Hi @AlenaS

You can define a new calculated member in the Project dimension and Aggregate the necessary Projects into one member:

step1
step12282×1514 88 KB

Next, select this member in the report and switch to Table chart. Expand the member to see the included projects, Order by the aggregated member, and Remove the column from the report.

step2
step21724×1716 95.2 KB

After removing the column, the Order will still be active until removed. You can now switch back to the Bar chart, and the report should show the Stacked bars ordered by the total Hours spent of all aggregated projects.

final
final2180×1150 42.9 KB

​Best regards,
​Nauris / eazyBI support

1 Like
3

Thanks a lot @nauris.malitis ! It works, exactly what I need to. Thanks for so good description

1 Like