topic Re: Cumulative % based on dimension. in App Development

Cumulative % based on dimension.

MuraliPrasath — Sat, 16 Nov 2024 02:58:07 GMT

Hi,

I have following table and need to do cumulation with dimension values. When my Feild'Flag' is 'No' then cumulation should not happen. Need help on this.

Re: Cumulative % based on dimension.

tresB — Tue, 17 Mar 2020 05:53:38 GMT

Screenshot is good while explaining your issue. However, sharing the actual file (here excel) would be better since that would allow people here to try out few things with the data in the course of proposing a possible solution to your query.

Re: Cumulative % based on dimension.

MuraliPrasath — Tue, 17 Mar 2020 06:14:39 GMT

Hi,

I've added the worksheet. Let me know if you need any other information.

Re: Cumulative % based on dimension.

tresB — Tue, 17 Mar 2020 06:24:54 GMT

Can I assume that you are trying to achieve this in a table chart , and 'Cumulative Flag%' is what you need to get?

Re: Cumulative % based on dimension.

tresB — Tue, 17 Mar 2020 06:42:24 GMT

If my assumptions are correct, you may try like:

rangesum(above(total If(Flag='Yes', sum(Sales)/sum(Total Sales)),0,RowNo(Total)))

Re: Cumulative % based on dimension.

MuraliPrasath — Tue, 17 Mar 2020 06:58:31 GMT

Thank you so much. This worked as expected.😊