topic Stacked bar chart that adds 100% from multiple columns in App Development

Stacked bar chart that adds 100% from multiple columns

Anonymous — Sat, 16 Nov 2024 09:35:16 GMT

Given the following data, how can i produce a graph that shows:

The Column CAT as a dimension

The Column Month as a sub-dimension

The Sum of F1+F2+F3 as a stacked bar chart, that always has a total of 100%

sunny_talwar — Mon, 26 Jun 2017 17:36:36 GMT

May be this

=Sum(RangeSum(F1, F2, F3))/Sum(TOTAL <CAT> RangeSum(F1, F2, F3))

Anonymous — Mon, 26 Jun 2017 18:14:07 GMT

Hi,

That's almost it, there's only one point that i didn't explain in my opening post.

The Sum of F1 should only be calculated when the month=1.

The Sum of F2 should only be calculated when the month=2.

The Sum of F3 should only be calculated when the month=3.

I modified my example data, only the values in bold should be calculated:

sunny_talwar — Mon, 26 Jun 2017 18:29:19 GMT

May be like this

=Sum(RangeSum(Pick(MONTH, F1, F2, F3)))/Sum(TOTAL <CAT> RangeSum(Pick(MONTH, F1, F2, F3)))

sunny_talwar — Mon, 26 Jun 2017 21:17:33 GMT

Sample attached