How to create 100% stacked columns with absolute number

[Anonymous]

Hello!

I need to create the chart as shown: columns have the same height, but they show different values segmented by Groups. Is it possible?

Id est, I would like to replace the percentage with the absolute values, keeping the proportion of the percentage.

Thanks!

Elena

[sunny_talwar]

May be make use of Dual() function. Something like this:

Dual(Sum(Field), Sum(Field), Sum(Total <Year> Field))

May be share a sample for more help.

[Anonymous]

Thank you, but I think it doesn't work...

I attched example files.

Thanks!

Elena

[sunny_talwar · Accepted solution]

This?

[Anonymous]

Yes, thanks, you are very kind!

Elena