Doubt about Chart 100% Stacked

[rafaeloneil]

Staff, good afternoon,

I am a beginner in the use of what I'm looking for help with a question on this chart.

I have the information below

and would like to know how to make the graph 100% Stacked (2):

if not equal, similar to the graph (3)

My Dimension:

=MonthName(DTCONTRATO_QTD)

My Expression:

SUM(PND_COML_QTD)

SUM(PND_DOC_QTD)

SUM(FORM_OK_QTD)

[lakshmikandh · Accepted solution]

Hi

Can you try this

SUM(PND_COML_QTD) / SUM(PND_COML_QTD+PND_DOC_QTD+FORM_OK_QTD)

SUM(PND_DOC_QTD) / SUM(PND_COML_QTD+PND_DOC_QTD+FORM_OK_QTD)

SUM(FORM_OK_QTD) / SUM(PND_COML_QTD+PND_DOC_QTD+FORM_OK_QTD)

Thanks,

Lakshmikandh

[sunny_talwar]

Or this:

SUM(PND_COML_QTD)/RangeSum(SUM(PND_COML_QTD), SUM(PND_DOC_QTD), SUM(FORM_OK_QTD))

SUM(PND_DOC_QTD)/RangeSum(SUM(PND_COML_QTD), SUM(PND_DOC_QTD), SUM(FORM_OK_QTD))

SUM(FORM_OK_QTD)/RangeSum(SUM(PND_COML_QTD), SUM(PND_DOC_QTD), SUM(FORM_OK_QTD))

[rafaeloneil]

It worked, thanks guys