Stacked bar charts sorted by total, but without showing total


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?

Hi @AlenaS

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

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.

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.

​Best regards,
​Nauris / eazyBI support

1 Like

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

1 Like