Hide Totals in Charts

[Former Member]

Hi,

I am using hierachies in my (test-) dashboard and want to visualize the data in a crosstab and a chart.

The user should be able to expand the hierarchy.

Unfortunately there is a problem, that the chart shows the totals.

When I select hide totals (chart properties and initial view) then there a empy spaces in the charts (see image below) which I want to hide too, but actually I have no idea how to do this.

Maybe someone knows a workaround how I can hide this without losing the hierarchy.

Regards,

Steffen

[TammyPowlas]

I couldn't get anything to work - in either Design Studio or the BEx Query

It might make more sense to show the totals in both the cross tab and the graph.

[Former Member]

Hi Tammy,

thanks for the answer.

I think both alternatives are not ideal.

If crosstab and chart show the totals it will look like this:

Even though this is correct, especially the chart looks somehow wrong when showing totals for the year and the values for each quarter.

So you are not able to see a trend.

(I know that I can use another DS without hierarchy to show trends, but I hoped this is possible with the usage of hierarchies.)

It should look like this:

Totals in the crosstab, no totals in chart but working hierarchy.

You have the option for chart to show or hide totals, maybe it will be possible to add a function to show or hide totals when using hierarchies?

As the values are on another level of the hierarchy they may be displayed in the chart in a different colour?

It would be nice if charts with hierarchies can look like this:

Regards,

Steffen

[TammyPowlas]

Hello Steffen,

I agree with you on this.

I am wondering if Design Studio is ignoring this property in the chart:

Totals are set to False, but when you start navigating they show anyway.

If you agree, you may want to contact SAP Support and open an incident.  This is just my take only.

[Former Member]

Hi Tammy,

you are right, but I think this is not a real bug.

When switching totals on or off, the chart does not ignore this setting, it will show an additional bar for the total.

But when using hierarchies the chart does not handle them as you would expect.

Because I think the actual state is no good solution I submitted this at the DS idea place.

Regards,

Steffen.

[TammyPowlas]

Great Steffen - could you share the link to your idea in Idea Place?

[Former Member]

https://ideas.sap.com/D20988