Cumulative % based on dimension.

[MuraliPrasath]

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. 

[tresesco]

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.

[MuraliPrasath]

Hi,

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

[tresesco]

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

[tresesco · Accepted solution]

If my assumptions are correct, you may try like:

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

[MuraliPrasath]

Thank you so much. This worked as expected.😊