Custom Grand Total on Line Graph

Question

Hi,

I have Line Graph with colulmn called: Savings [%].

It is calculated as follows: (Savings [EUR] * 100.0) / Amount [EUR]

And graphs looks like:

Three colors it's a three different organization (for example A,B,C)

And now I want create a grand total on graph, for all organizations but BY MONTH. For each month calculated grand total.

The grand total for this should be calculated as follows: (SUM(Savings [EUR]) * 100.0) / SUM(Amount [EUR]). In pivot table it's working fine, when I have on savings [%] column, aggregate rule is Default and it's ok.

But how can I add this on graph? With ma custom formule and not divide by organization?

The above graph has this calculating because I not use Vary Color By Organization.

I think that I want to merge above two graphs. Can I?

choracy69 · Answer

Hi Thomas,

Thanks for reponse.

In rpd in my organization dimension i have something like that:

And ok in table is working fine, the measure in ALL it's a TOTAL and in details it's a details for each organization.

But how create graph with these measures?

I want what --> SAVINGS [EUR] and SAVINGS [EUR] #1 (both measure in time have Day Details in rpd)

* SAVINGS [EUR] by Organization
* SAVIGNS [EUR]#1 - one line for all organization

I get:

* Savings [EUR] - bar - it's ok
* Savings [EUR]#1 - my total - I have color for each organization but I want one line.

Graph Properties:

I know that I have Vary Color By - Organization, but I must have this.

Thomas Dodds · Answer

what you need is a dimension value that represents all organizations and your measure logically aggregated to it

OR

plot a level-based measure (built in RPD) at Org-Total on a second vertical axis.